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