select ItemCode,ItemName,FrgnName,ItmsGrpCod,CstGrpCode,--VatGourpSa,CodeBars,case VATLiable when 'Y'then 'tYES' when 'N'then 'tNO' end 'VATLiable',case PrchseItem when 'Y'then 'tYES' when 'N'then 'tNO' end 'PrchseItem',case SellItem when 'Y'then 'tY...