This is a frequent request in newsgroups and fora. People want to sort the column in ascending order but don't want the NULLS at the beginning. Oracle has this syntax: ORDER BY ColumnName NULLS LAST;SQL Server does not have this. But there are 2 ways to do this. The first one is by using case and the second one by using COALESCE and the maximum ...