IN statement within a CASE statement

[AtlPayroll]

I'm creating a Derived field.

I've got a CASE statement that currently works:
CASE "JOB"."JOBCODE"
WHEN 'COP367'
THEN 'YES'
ELSE 'NO'
END

What I'm needing is to incude a an IN statement
CASE "JOB"."JOBCODE"
WHEN IN('COP367','COP368','COP369')
THEN 'YES'
ELSE 'NO'
END

But I get an ORA-00936: missing expression error. Does anyone know what I'm doing wrong?

Thanks,

 

[CharlesCook]

Try this:

CASE WHEN "JOB"."JOBCODE" IN('COP367','COP368','COP369')
/* You could put some comments in here */
THEN 'YES'
/* You could put some comments in here */
ELSE 'NO'
END

http://CharlesCook.com

Specializing in ReportSmith Training and Consulting