SQL Server 2005: Order with NULL values at the end [duplicate] SQL Server 2005: Order with NULL values at the end [duplicate] sql sql

SQL Server 2005: Order with NULL values at the end [duplicate]


I found a way to order NULL values on the bottom.

http://sqlblog.com/blogs/denis_gobo/archive/2007/10/19/3048.aspx

It meets my needs quite nicely. My query is now:

select *from tableNameorder by case when ordernum is null then 1 else 0 end, ordernum