need help

[Mike]

I'm creating asp.net using C# and I'm going against a SQl db. One table i'm
going against i need to pull FirstName from one column and LastName from a
seperate column.

How can I join these 2 columns in my query and display them together in my
datagrid?

 

[Steve C. Orr [MVP, MCSD]]

SELECT FirstName + ' ' + LastName AS FullName FROM MyTable

 

[Mike]

Ok thanks, got that, now how can i have the lastname first seperated by a
comma then the firstname?
Like.

Doo, Scooby

 

[Mike]

I figured it out.
early in the morning and i didn't have my thinking cap on yet