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]
- RE: SQL custom Order by Mark W. Breneman
- RE: SQL custom Order by Andrew Tyrone
- RE: SQL custom Order by Plunkett, Matt
- RE: SQL custom Order by David Jones
- Re: easy question Tony Weeg
- RE: SQL custom Order by Mark A. Kruger - CFG
- Re: SQL custom Order by Jochem van Dieten