I have a Pass Through QUery in Access that pulls data from an Oracle database. This query works okay, but when I include the case statement within the SQL it does not work.

If I run this query via Perl, or at SQL> prompt itself, it works with the case statement. Can someone tell me what to do? I presume this is ODBC driver issue, but any suggestions would be helpful.