SQL Server：带有NULL值的ORDER BY变量列CASE语句

I've got a query that can spit out results sorted by a variety of columns, but I need to be able to handle null values in the sorted columns. Any help would be greatly appreciated. Here is an example:I've got a query that can spit out results sort