• This will give you the string in the right format:

    --select all the rows into the variables

    select

    @Numbers = @Numbers + iNumber,

    @Strings=CASE @Strings WHEN '' THEN sNumber ELSE @Strings + ', '+sNumber END

    from @demo

    Excellent trick.

    Nick