const itemResult: IResult<GPItem> = await pool
    .request()
    .input('itemNumber', itemNumber).query(`SELECT top 1
      rtrim(ITEMNMBR) as itemNumber,
      rtrim(ITEMDESC) as itemDescription,