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? Im looking for something like this:

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

Of course, that doesnt 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 cant?

 

[joe_pool_is]

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

Thanks Plausibly!