[RESOLVED] Combining columns in a sql query

[netfrugal]

I essentially want to say this:

SELECT firstName + lastName AS fullName from table1

Can this be done?

[NogDog]

In MySQL:

SELECT CONCAT_WS(' ', firstName, lastName) AS fullName FROM table1

(I'm assuming you want a space between the names. If not, just use CONCAT(firstName, lastName).)

[netfrugal]

Thanks! You were right. I do want the spaces. Of course, I had to test both to see for myself!