SQL: How can I order null and empty entries to the front in an orderby?

sql sql-server tsql

ORDER BY     CASE     WHEN Name IS NULL THEN 1     WHEN Name = ''    THEN 2     ELSE 3     END DESC,     Name ASC

sql sql-server tsql

You can do it like this:

ORDER BY CASE WHEN Name IS NULL then 3 WHEN Name = '' THEN 2 ELSE 1 END, Name

It will order with by the number in the case first and afterwords by the Name.

sql sql-server tsql

ORDER BY CASE     WHEN Name IS NULL THEN 1     WHEN Name = '' THEN 2     ELSE 3END DESC,Name ASC

CodeHunter