Concatinate two fields into one? Not sure what the SQL syntax is

[Denaes]

I have a standard customers table, with all the customers fixings and I want to tag on another field to my select statement.

 

It'll take Lastname and Firstname in this format: "Lastname, Firstname" and the name of the calculated field will be Fullname. This is merely a calculated field to help with databinding to a combobox and listbox.

 

I'd appreciate some help, but I'll keep working on it and post the answer if I do find it.

[PlausiblyDamp]

SELECT LastName + ', ' + FirstName as FullName FROM

[Denaes]

Damn that was fast. I only got a chance to try it once and I used the & sign as the concatinator and got an error.

 

Thanks for the help :)

[techmanbd]

You can also do it theis way if my memory serves me

 

SELECT firstname || ", " || lastname as fullname from TABLE