This article is tagged with:
Sql select merge multiple values
and mysql
sql select merge multiple values
DECLARE @combinedString VARCHAR(MAX)
SELECT @combinedString = COALESCE(@combinedString + ', ', '') + column_name
FROM table_name
WHERE ID = 1234
SELECT @combinedString as StringValue