SQL custom Order by

[Mark W. Breneman]

I doubt this is possible, but is there a way to do a custom order by based
on the order I provide?  I need the SQL results to be in a specific order
based on the "catID", but not in ascending or descending order. The order
that I want them in is 10,3,5,1,7,4,9,2,6,8.

Example

Select *

>From table

Order by catID values(10,3,5,1,7,4,9,2,6,8)

I am using MS SQL 2000.

Thanks for the help.

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---