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