T-SQL CASE Clause: How to specify WHEN NULL October 6, 2022 by Tarik CASE WHEN last_name IS NULL THEN '' ELSE ' '+last_name END