Converting multiple rows into a single comma separated row


I am using an advanced query, in which i wish to convert multiple rows into a single comma separated row.

Thanks in Advance.

Swaroop Mutalik
Hi Swaroop,

You can make a for each after the query.
Hi Nuno,

Thanks for the kind reply.

Can u please show give us an example for this,will be very helpfull

Thanks & Regards,
Swaroop Mutalik
Hi Swaroop,

Or you can continue using an Advanced Query with this technique if you're using SQL Server:

Depends how you retrieve the data.

- if you use Oracle, then you can group by and wm_concat the stuff.
- if you already place it in 1 text in the query, you can either do a for-each loop
or use the string_join action from the Text(?) extension.