DECLARE @vs varchar(1000) set @vs = '' SELECT @vs = @vs + ',''' + LSBZDW_DWBH + '''' FROM LSBZDW PRINT @vs