Equivalent of Oracle Decode in Order by clause

[BadRabbit]

Hi, I'm bring back some username records and I want to order them alphabetically but I always want the record containing the word "General" to come last.

In Oracle it's easy:

SELECT...FROM...WHERE...
ORDER BY DECODE(my_field,"General","ZZZZZ",my_field)

Does anyone know how to do it in SQL Server 2000?

Thanks.

 

[sunila7]

Hi,

Try this... Have a look at CASE statement..

SELECT * FROM tbl
ORDER BY
CASE my_field when 'General'
Then 'ZZZZZZ'
ELSE my_field
END



Sunil

 

[BadRabbit]

Thanks, that looks like it'll do the trick.