DECLARE @combinedString VARCHAR(MAX) SELECT @combinedString = COALESCE(@combinedString + ', ', '') + column_name FROM table_name WHERE ID = 1234 SELECT @combinedString as StringValue