using case statement

Hi Friends,
 I want to use "in" clause in case statement as shown below. e.g
select * from employee
where empid in

               case i_desgn
                when 'HR' then (1,2,3,4,5)
                when 'MD' then 1
                else   7
                end

Though i did this using if-elsif but there is repetation of query. So i want this way to implement..Please help as soon as possible..

Thanks
Priyabrata Received on Tue Mar 11 2008 - 22:38:25 CDT