Column Alias Queston 2

[Rob7412]

I have a db with three field ptfname,ptmint,ptlastname

Is there any way to select these three fields as a alias such as patientname with the fields formated like this

Smith, John T

 

[gmmastros]

Select IsNull(ptLastName, '') + ', ' 
       + IsNull(pfFName, '') + ' ' 
       + IsNull(ptMInt, '') As PatientName
From   Table

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[SQLDenis]

one way

select ptlastname + ', ' + ptfname + ' ' + coalesce(ptmint,'') as patientsname
from table.........

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[Rob7412]

Thanks it's just what I needed