SELECT *
FROM Table
ORDER BY CASE FormatDescription
         WHEN 'Other' THEN 1
         WHEN 'N/A' THEN 2
         ELSE 0
         END ASC,FormatDescription ASC

quote:

---

Originally posted by visakh16

SELECT *
FROM Table
ORDER BY CASE FormatDescription
         WHEN 'Other' THEN 1
         WHEN 'N/A' THEN 2
         ELSE 0
         END ASC,FormatDescription ASC

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

---