First seen at Kabisa Blog: SQL: Ordering with NULL values
This post tells you how to sort NULL values in a column to the bottom and sort the remaining non-NULL values.
This is really great in combination with LEFT JOIN queries that may yield NULL values.