CASE function

[abowling]

I have a list of employee annual salary rates.
I would like to return a value (ie A, B, C etc) when the annual salary rate falls within a salary range.

Here is what I tried:

CASE "PS_EMPLOYEES"."ANNUAL_RT"
WHEN '>22359 AND <28080 THEN 'A'
WHEN '>28079 AND <35360 THEN 'B'
ELSE 'NONE'
END

I am getting the missing right parenthesis error. Any help would be greatly appreciated.

 

[CharlesCook]

This will depend on the database you are using. With Oracle it would be:

CASE
WHEN "PS_EMPLOYEES"."ANNUAL_RT" > 22359 AND "PS_EMPLOYEES"."ANNUAL_RT" < 28080 THEN 'A'
WHEN '"PS_EMPLOYEES"."ANNUAL_RT" > 28079 AND "PS_EMPLOYEES"."ANNUAL_RT" < 35360 THEN 'B'
ELSE 'NONE'
END


CharlesCook.com
ADP - PeopleSoft - SAP
ReportSmith - Crystal Reports - SQR - Query - Access
Reporting - Interfaces - Data Mining

 

[abowling]

Thanks I will give that a shot. I am using Oracle.