Concatenate multiple columns in single row in SQL Server

Hi iammann,

Refer the below sample query. You need to convert the fields like int to varchar to concadinate.

DECLARE @Test AS TABLE(ID INT,FIRSTNAME VARCHAR(50),LASTNAME VARCHAR(50),AGE INT)
INSERT INTO @Test VALUES(1,'Ram','Singh',25)
INSERT INTO @Test VALUES(2,'Rahim','Khan',38)
INSERT INTO @Test VALUES(3,'David','Morkel',52)
INSERT INTO @Test VALUES(NULL,NULL,NULL,NULL)
SELECT  ISNULL(CONVERT(VARCHAR(50),ID),'') + ',' +
        ISNULL(FIRSTNAME,'') + ',' +
        ISNULL(LASTNAME,'') + ',' +
        ISNULL(CONVERT(VARCHAR(50),AGE),'') AS BusiNessfocus 
FROM @Test

Output