Combine Multiple records into one

[werks]

Hello experts could someone tell me how can i combine multiple records into one value.

Sample in MS Access:
(Lastname & "" & "," & " " & Firstname) AS Name

How can i do this in MySQL?..tnx in advance

--
Kenneth
"Better Than Yesterday"

[ronverdonk]

I think you are talking about combining different column values into one. Even simpler in MySQL:

SELECT CONCAT(LastName, ', ', FirstName) as Name ....

Ronald

[werks]

That's it!! Many thanks!..

--
Kenneth
"Better Than Yesterday"

[ronverdonk]

You are welcome. See you again some day.

Ronald

[werks]

You are welcome. See you again some day.

Ronald

Ok..thanks again.

--
Kenneth
"Better Than Yesterday"