SQL Server Performance Forum – Threads Archive
handling NULL’shi, We have a table were in one of the columns has null’s and some valid numbers- Table name – Customer
seq Example records-
seq-NULL Now when we write "Select * from customer order by Seq,name " it returns first all null’s and then the rest in asc order. Is there a way that we can first display the numbers in asc then the null records ? please replyback soon as it is URGENT. Thanks.
ORDER BY ISNULL(Seq, 9999999), name
Thank you very much its works [<img src=’/community/emoticons/emotion-1.gif’ alt=’‘ />]<br />