handling NULL's | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

handling NULL’s

hi, We have a table were in one of the columns has null’s and some valid numbers- Table name – Customer
Id
name
seq Example records-
Id -1
name-xxx
seq-2 Id-2
name-yyy
seq-3 Id-3
name-zzz
seq-NULL Id-4
name-aaa
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 />
]]>