EASY ? Case statement

Hi There,

What is the right syntax to do this :

 select case ename when ('SCOTT') then 'IIII' else 'CCCC' end as test ,  ename from emp;

This code returns an error ORA-00923

Best Regards,
Olivier. Received on Thu Nov 02 2000 - 11:18:48 CST