Merging SQL Columns for display

[joe_pool_is]

We need to display the Employee name as a single "LastName, FirstName" column in our DataGrid.

 

In the Employee table, these columns are separate:

SELECT LastName, FirstName
FROM dbo.Employee

Is there a way to format an SQL command so that these two columns get merged? I'm looking for something like this:

SELECT (LastName, ", " FirstName) AS "EmployeeName" 
FROM dbo.Employee

Of course, that doesn't work!

[PlausiblyDamp]

[Highlight=sql]

SELECT LastName + ', ' + FirstName as 'Employeename'

FROM dbo.Employee

[/highlight]

 

should do the trick with SQL Server

[joe_pool_is]

Wow! I got a reply from the Master! :)

 

I ran the code your way on the SQL Server through the Enterprise Manager GUI, and it worked fine.

 

However, whenever I tried using it in VS, I got the message "Incorrect syntax near the keyword 'AS'."

 

Is there any reason why SQL Server can run this but VS can't?

[joe_pool_is]

Whoops! Syntax issues. I forgot to include the "+" before FirstName.

 

Thanks Plausibly!