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

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 

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"