FirstName, LastName in SQL, too complex?

Question

This SQL seems complex, is there an easier way to get FirstName, LastName when one or both of the fields can be NULL?

SELECT COALESCE(LastName,'')+
       CASE WHEN LastName+FirstName IS NOT NULL THEN ', ' END+
       COALESCE(FirstName,'') AS Name
FROM Person

Answer 1

How about

SELECT COALESCE(LastName + ', ' + FirstName, 
                LastName, 
                FirstName) Name
FROM Person

Answer 2

I don't think this is complex at all... On MSSQL you can do something like

SELECT Isnull(LastName,'') + ', ' + Isnull(FirstName,'')
FROM Person