Distinct column content

Hi,

I have some question,

I have table with 2 columns

id symbol

11   abc,bbc,abf,cde
22   rda,abc,aig
33   ibm,aig,sun
55   aig,klm,suk,sun
23   bbc,kln,sun,adf

I need to select distinct symbol strings from symbol column,they shoudn't be repeated,but should be comma separated as they appear in a column.
the result to user should be like:
abc,bbc,abf,cde,rda,aig,ibm,sun,klm,suk,kln,adf...

Any ideas are really appreciated,

Marina Received on Mon Feb 21 2005 - 14:58:33 CST