I will explain how to write a query to concatenate two columns of data to single column in datatable using SQL server.

Thank you for reading this post, don't forget to subscribe!

Two Syntax:

Syntax 1:

SELECT (CONVERT(varchar(50),Column1)+’ ‘+CONVERT(varchar(50),Column2)) AS ConcatnatedColumnFROM TableName

Syntax 2:

SELECT (CAST(ColumnName1 AS varchar(50))+’ ‘+CAST(ColumnName2 AS varchar(50))) ASConcatnatedColumn FROM TABLENAME