Select SaleItemID, CategoryID, ItemID, ItemNo, Description, isnull(HtmlSummary,'') as HtmlSummary, isnull(cast(HtmlDescription as text),'') as HtmlDescription, isnull(IconLocation,'') as IconLocation, SalesPrice, RentalPrice, FinancialPrice, IsLicense, ChargeType, isMonthlyCharge, MonthlyPayment from TSaleItem where CategoryID = 77 and isActive = 1 and not SaleItemID = 2279 order by OrderNumber
