Aliasing Two Columns In SQL

Hi,

Here is my original query:

select rosterid, lastname, firstname from table
order by lastname


I would like to use column aliasing to display
lastname, firstname in a column entitled name.

I tried the following syntax, but it's not working:

select rosterid, lastname+', '+firstname as name
from table
order by name

This results in a 2 column table with the headings "ROSTERID" and
"NAME". However, NAME contains th last name only, rather than "lastname,
firstname".

Any help greatly appreciated.

Thanks,
Google Jeny


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!