CASE with multiple criteria

[Atrzy]

Is it possible to write a CASE statement using AND?

Here's an example of what I'm trying to do:
If Location = 0001E and Jobcode = 900922
Then return Director
If Location = 0001 and Jobcode = 900922
The return Allocator
Else NA

I don't know how to properly write the CASE statement.
I'm on Oracle 9, using Report Smith 3.0

Thanks for any help you can give me!

 

[ReportSmithing]

Yes...you'd write it like this:

Case
When Location = '0001E' and Jobcode = '900922'
Then 'Director'
When Location = '0001' and Jobcode = '900922'
Then 'Allocator'
Else 'NA' End

 

[Atrzy]

That worked. Thanks!