SQL & PL/SQL

Hi ,

I have following query from my custom tool, bind variable value arecoming like this ( '1000,8000' ) :


select * from table where check_number IN ('1000,8000')

In above sql 1000 and 8000 are two check numbers user entered in Text field prompt. I just tried to convert that into '1000','8000' wt following replace statement:

select chr(39)||replace('1000,8000',chr(44),chr(39)||chr(44)||chr(39))||chr(39) from dual ---this is working fine as expected.

Its not working if replace same in my main sql:

select * from table where check_number IN (chr(39)||replace('1000,8000',chr(44),chr(39)||chr(44)||chr(39))||chr(39))

Could you please help me to resolve this or provide me another way to do it ?

Thanks in advance!!