convert string to number
406871Apr 30 2007 — edited May 1 2007Hello
I want to convert a comma seperate string into a number in a where clause i.e
say:
enum varchar2(40);
enum='83152,100004455';
but in a query
select abc from t1
where empnum in enum;
but empnum is a number in a table;
Regards