dynamic 'In' clauses

Must be simple this.....

v_ename Varchar2(10 ) := 'FRED'

Select empno
from emps
where ename IN ( v_ename );

Problemo,... How do i get it to work if i want 2 values in v_ename

eg. v_enmae := 'FRED'||','||'Sally';

Cheers Huwski Received on Mon Aug 10 1998 - 05:23:05 CDT