Hi Gurus !!



I have a comments table that has multiple comment records for the same Code.


Is there a way to get the concatenated string of all comments for a
particular code in query in DB2UDB ??



Ex :

Table wc_cmnts has a column called wc_cd (VARCHAR(30) and a column called
seq_no (int) and a column called cmnts (VARCHAR(1000).

There can be multiple records for the same wc_cd with different seq_no.

I want a query to concatenate all the cmnts for a particular wc_cd in the
order of the seq_no.





Can it be done ??



Thanks!!

Sravanthi




DB2 & UDB email list listserv db2-l LazyDBA home page