concatenate multiple columns of a row into a single row or string

Question

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: JohnCruzPhilippines I just need it now.. help help.. thanks

Senthilkumar · 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.

anand sengar · Answer

don't forget to use isnull if your columns can also have null value. otherwise result will be not proper. SELECT isnull(FirstName'')+' '+isnull(LastName'')+' '+isnull(MiddleName'') AS FullName FROM table_name

MuthuMari M · Answer

Hi SELECT (FirstName + '  ' + LastName '  ' + country) Employee First & Last Name FROM Employees ORDER BY FirstName ASC Pls refer this for more samples http://www.mysqltutorial.org/mysql-join-subqueries.aspx Thanks. If this post is useful then mark it as  Accepted Answer