sorting question...

[captlid]

I have two columns, one is an int and the other is a date,
I want the records to show first the null values in the int column and have that sorted by date, then the rest of the rows sorted by date.

I tried doing

order by int asc, date asc, but it only orders the null values properly.

so this should be the result:
date, int
3/12 null
3/13 null
3/8 5
3/9 4
3/10 4
3/11 5

thanks

 

[swampBoogie]

order by case when intColumn is null then 0 else 1 end,
dateColumn

 

[captlid]

i didnt know you can put queries inside the order by clause, cool thanks.