Concatenate String Data in Result Set from More Than One Columns of Database Table

Question

Hi friends I want to know how to concatenate string data in result set from more than one columns of database table in SQL Server ? Thank you.

Vulpes · Answer

Something like this perhaps: Select Name + ' ' + Surname As FullName From Employee Where Category = 'Full Time'

Satyapriya Nayak · Answer

Hi Vipendra Create table table1(field1 varchar(50)field2 varchar(50)field3 varchar(50)) INSERT INTO table1 VALUES ('hello' null 'world') SELECT (COALESCE(field1 '') + '' + COALESCE(field2 '') + '' + COALESCE(field3'')) FROM table1 Thanks