SELECT FIRST, LAST
FROM CUSTOMER

SELECT COALESCE(FIRST, ''), LAST FROM CUSTOMER

SELECT COALESCE(FIRST, SECOND, THIRD, '')...

SELECT isnull(FIRST,'') AS FIRST, LAST FROM CUSTOMER

select isNull(First,'') from customer

SELECT COALESCE(FIRST, ''), LAST FROM CUSTOMER