Concatinated Column Names in a SELECT?

[MetalEdge]

Hello. I'm using MySQL with .NET, and I'm having an issue with writing a query that will combine two columns into one result set. This is much like the Microsoft way of doing:
SELECT LastName + ' ' + FirstName FROM tbl1

So the result would be
Doe Jane
Doe John ...

I can't imagine this is impossible to do in MySQL, so are there any ideas? Many thanks!
Bryan

 

[danielhozac]

[tt]SELECT CONCAT(LastName, ' ', FirstName) FROM tbl1[/tt]

//Daniel

 

[MetalEdge]

Perfect, thanks so much!

Bryan