MySQL and column concatenation in a SELECT?

[Netnoobie]

Hello. Im using MySQL with .NET, and Im 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 cant imagine this is impossible to do in MySQL, so are there any ideas? Many thanks!
Bryan

 

[jfackler]

SELECT CONCAT(LastName, " ",FirstName) FROM tbl1

 

[Netnoobie]

Many thanks!