dBforums - View Single Post - Split rows into one row as comma delimited string

tyaramis · #1 (**permalink**) 11-27-09, 05:30

HI All

Is it possible to generate such a result set with a query in informix?

With my existing query I am getting this resultset:

SystemName Numbers
A 111
A 222
B 123
B 356
B 777
C 888

and I would like get a result set like this:

SystemName Numbers
A 111;222
B 123;356;777
C 888

Thanks alot in advance.