CASE e WHEN null

SELECT CASE WHEN last_name is NULL THEN first_name ELSE first_name + ' ' + last_name