Very nice, but...

I used that in my production database.

Query:

DECLARE @listValues VARCHAR(8000)

DECLARE @how_much int

SET @how_much = 0

SELECT @listValues = ISNULL(@listValues + ';' + rTRIM(CAST(inv.NUMBER AS VARCHAR(8000))),

rTRIM(CAST(inv.NUMBER AS VARCHAR(8000)))),

@how_much = @how_much + 1

FROM INVOICE AS inv

ORDER BY inv.NUMBER

SELECT list = @listValues, how_much = @how_much

and I've got:

list=ZZ/1573/04/10

how_much=1

but with query:

DECLARE @listValues VARCHAR(8000)

DECLARE @how_much int

SET @how_much = 0

SELECT @listValues = ISNULL(@listValues + ';' + rTRIM(CAST(inv.NUMBER AS VARCHAR(8000))),

rTRIM(CAST(inv.NUMBER AS VARCHAR(8000)))),

@how_much = @how_much + 1

FROM INVOICE AS inv

SELECT list = @listValues, how_much = @how_much

I've got:

list=FV 1/2009;FV 2/2009;P 1/2009;P 2/2009;FV 3/2009;FK 1/2009;FV 4/2009; FV 574/09;1498222;FV 5/2009;425/09/RA;FV 6/2009;FV 7/2009;FV 8/2009;FV 9/2009;FV 10/2009;FV 11/2009;FV 12/2009;FV 13/2009;FV 14/2009;FV 15/2009;FV 16/2009;FV 17/2009;FV 18/2009;FV 19/2009;FV 20/2009; ...

and much more:-)

because the how_much was 5272