how to condense several rows of a select?

I want to condense several rows of a select. mytable :
1 a
2 b
2 c
2 d
3 a

so that my select should result in

1 a
2 b,c,d
3 a

Any idea to achieve this result?
SP Received on Fri Feb 02 2001 - 18:18:08 CST