For each row in SQL Server

Question

Hello

I got a table with one column eg: col1 and 5 records.

Eg: tablename: Table1

Col1
-------
aaaa
bbbb
cccc
dddd
eeee

I want to build a string based on col1 values as something below:

set @stringVariable = ''aaaa', 'bbbb', 'cccc', 'dddd', 'eeee''

How can this be done.

Answer 1

DECLARE @stringVariable varchar (8000)
SET     @stringVariable = NULL  -- MUST be null to avoid leading comma.

SELECT
    @stringVariable     =  COALESCE (@stringVariable + '''' + ', ''', '') + Col1
FROM
    Table1

SET     @stringVariable = '''' + @stringVariable + ''''