Thanks Ward - thought so.....

Peter:

sorry, may not have been the right choice of words.....i tried to explain it through the example - i assume that when you use a table...

Hi Johathan,

I think it is called pivoting a table. e.g.

DELCARE @test-2 VARCHAR(256)

SET @test-2 = ''

SELECT  @test-2=@Test+[ColumnName]+','

FROM [Table]

PRINT @test-2

Maybe try and place the...