Clay Shannon wrote:

>What need I do to only return records with first and last names, but to also
>display the middle name when there IS a middle name?
>
>
>

SELECT
A.REFERRAL_DATE, A.ADMIT_DATE, A.DISCHARGE_DATE, A.CLOSE_DATE,
C.LASTNAME || ', ' || C.FIRSTNAME || COALESCE(' ' || C.MIDDLENAME, '') AS NAME,
C.CLIENT_STATE
FROM
...


--
Magnus