SQL & PL/SQL

Hi all,

My code checks similar condition as below.

how can return multiple values for THEN in CASE.

I know that l_status stores only 1 value. But I want something like l_status = 'n','s'

I am using this case statement in the where condition.

If not CASE is there any other way that I can handle.

Please suggest.

---code

case

when

(l_eno is null and l_ename is null)

then

l_status = 'n'

(l_eno is not null and l_ename is not null)

then

l_status = 'n','s'

end