SELECT A +' ' + B + CASE WHEN ISNULL(C,'') = '' THEN ' ' ELSE ' / ' END + D + CASE WHEN ISNULL(E,'') = '' THEN ' ' ELSE ' / ' END + F AS PERSON FROM DUAL