1.SELECT * FROM table1 ORDER BY CASE WHEN Col Is NULL Then 1 Else 0 End, Col
2.SELECT * FROM table1 ORDER BY isnumeric(col) desc,col