You can use ISNULL in the order by.  If you're ordering a column containing values 1,2,3,4... you'd use ISNULL(column, 0) to put them at the top or ISNULL(column, 99999) to...