Hi,
in my code
-SET &filter1 = IF &empno NE '' THEN 'emp.empno in (&empno)' else '';

select emp.empname,emp.sal
from emp as emp
where
emp.sal >1000 and
&filter1 ;
now the problem is when i am entering the values for &empno (for ex 123,456 ) then in my sql query it is replacing &filter1 with
emp.empno in (&empno) instead of replacing it as
emp.empno in(123,456).
thanks

Use:

 -SET &filter1 = IF &empno NE ' ' THEN 'emp.empno IN( &empno.EVAL )' ELSE ' '; 

or:

 -SET &filter1 = IF &empno NE ' ' THEN 'emp.empno IN (' | &empno.EVAL | ')' ELSE ' ';