Ignored.

>UPDATE: Nevermind. Error was with the developer.
>
>I get an error if I add the cPatientNumber line that PatientNumber cannot be found. I thought this was allowed. There will only be one record ever in the result and I want the specific value of cPatientNumber in that column.
>
>

>SELECT ;
>	cPatientNumber AS PatientNumber, ;
>	ALLTRIM(pt.ptLName) AS PatientLastName, ;
>.
>.
>.
>