Case Statement using NOT LIKE not working in Rpd
900390Feb 16 2012 — edited Feb 16 2012Hi
I am trying to use a case statement which has a NOT LIKE clause in it but the rpd defaults to a different statement when i try and save the case statement.
Here is my situation: When I put this case statement into the rpd expression builder for a column
Case WHEN "Dim - GL Segment3 - Minor"."Segment Code" NOT LIKE '%95' then 'Without Accruals' WHEN "Dim - GL Segment3 - Minor"."Segment Code"IS NOT NULL then 'With Accruals ' else "Dim - GL Segment3 - Minor"."Segment Code" end
when I try and save it ..it changes it to
CASE WHEN NOT Core."Dim - GL Segment3 - Minor"."Segment Code" LIKE '%95' THEN 'Without Accruals' WHEN NOT Core."Dim - GL Segment3 - Minor"."Segment Code" IS NULL THEN 'With Accruals ' ELSE Core."Dim - GL Segment3 - Minor"."Segment Code" END
which clearly is not the intent of the statement .. what is the workaround or rather what is the correct expression I can use to get the desired results