1 column values in to 1 single row in sql code example

Example: 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