sort the column Table_Description asc order except on field

/*     Alphabetize all products in the list    */
/*
SELECT ROW_NUMBER() OVER (  ORDER BY Table_Description ) AS RowNumber, *
into temp_table
FROM PMP_ListManagement

select * from temp_table


UPDATE PMP_ListManagement
SET Display_order = RowNumber
FROM PMP_ListManagement T
INNER JOIN temp_table CT
ON T.Table_Id = CT.Table_Id

drop table temp_table
*/

--After update table for particular value set top which u didnt want to update
update PMP_ListManagement set Display_Order = 0 where Display_Order = 'No Product'

---Now display records on asc order
select * from PMP_ListManagement order by Display_Order