Hi,

Try with this Concat query

DECLARE @VariableName DataType

SELECT

@VariableName = COALESCE(@VariableName + ', ', '') + ColumnName

FROM

DataBaseName

WHERE

ColumnName IS NOT NULL

SELECT @VariableName