Hi John,

The Link that you given only shown sample to remove double and single quotes.

But for my case, i need include the quotes.

Anyway thanks for your reply.:-)

Please help again...

Thanks for your advise, David

I already solve my problem with created another set of dataset in visual studio..

and this method is more faster than converting the data in percentage

because my...

Thanks All, now its work via this method.

select

deptno,

substr(SYS_CONNECT_BY_PATH(lname, ','),2) name_list

from

(

select

lname,

...