Loading

MS Sql Concatenate multiple columns of a row into a single row or string

jin

Hi,

I want to ask how would I concatenate multiple columns of a row into a single row or string?

Ex:

FirstName LastName Country
John Cruz Philippines

Result:
John,Cruz,Philippines

I just need it now..
help help..
thanks

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Senthilkumar14y ago
Accepted answer
Hi Jinky,

It is simple and you can concatenate the result as single column.

SELECT FirstName+','+LastName+','+Country AS [Result] FROM table_name

Try this and let me know.