How to display Row values in a single column ?

[mimi2]

Hi,
I have this table:
id value
1 neg
1 plus
3 neg
2 pos
1 nil
2 nil

i would like to transform it to:
id value
1 neg,plus,nil
2 pos,nil
3 neg
The order is very important.

I am looking for a solution without a cursor if possible.
I looked at this poste (thread183-774971 could not adapt it to my situation since i don't know in advance how many values an individual might have.

Thanks for any help.

 

[mimi2]

I had to use cursors and it is sloooooo

http://wwwww!

Does any one have an idea ? thanks a lot.