Loading

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

Vipendra Verma

14y1.5k

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.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes14y ago
Something like this perhaps:

Select Name + ' ' + Surname As FullName From Employee Where Category = 'Full Time'
Satyapriya Nayak14y ago
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