P.S. The 3 operand COALESCE will work fine if you want to return a NULL if both names are NULL. If, however, you want it to return an empty string if both names are NULL, just add '' as the 4th operand.
--Jeff Moden
Change is inevitable... Change for the better is not.