declare @result varchar(8000) declare @s varchar(32) declare c cursor FORWARD_ONLY READ_ONLY for select F1 from T order by F1 set @result = '' open c fetch next from c into @s while @@fetch_status = 0 begin if @result = '' set @result = @s else set @result = @result + ',' + @s fetch next from c into @s end deallocate c select '('+@result+')'