Missing Right Parenthesis Error

[Buckman0]

I have the following derived formula and get an error stating Missing Right Parenthesis. I'm not sure what is causing this...

CASE
WHEN RTRIM(JOB_POSITION.BARGAIN_UNIT_CODE) = '' THEN 'N'
WHEN JOB_POSITION.BARGAIN_UNIT_CODE IS NULL THEN 'N'
ELSE 'Y' END

 

[CharlesCook]

Missing Right Parenthesis is oracle's default error msg. It just means that it does not really know what the problem is. Lets try to narrow it down a bit.

Try this:

CASE
WHEN TRIM(JOB_POSITION.BARGAIN_UNIT_CODE) = '' THEN 'N'
END

Do you get the error?

If no then

CASE
WHEN TRIM(JOB_POSITION.BARGAIN_UNIT_CODE) = '' THEN 'N'
ELSE 'Y'
END

Do you get the error?

CASE
WHEN JOB_POSITION.BARGAIN_UNIT_CODE IS NULL THEN 'N'
END

Do you get the error?

If no then

CASE
WHEN JOB_POSITION.BARGAIN_UNIT_CODE IS NULL THEN 'N'
ELSE 'Y'
END

ps
rtrim will only trim on the right where trim will trim both sides.

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