Problems with "IN"

Can someeone help! This works:

SELECT * FROM sometable
WHERE 1 IN (1, 2, 3) ; But if I want something like this:

s_mylist VARCHAR2(20) := '1, 2, 3';

SELECT * FROM sometable
WHERE 1 IN ( s_mylist ) ;

It doesn't work. Can't I do this?

Thanks
Lisa Received on Wed Oct 15 2003 - 19:16:27 CEST