Recently, I met a sort problem on the null values, a record on sorted column is null, and this record always display on top even if the sort is asc or desc.
How To Sort
No 1
SELECT date
FROM MyTable
ORDER BY CASE WHEN date IS NULL THEN 1 ELSE 0 END, date
No 2
SELECT MyDate
FROM MyTable
ORDER BY date IS NULL, date DESC
FYI: click here to get more information.