I am using this sql query below to bring back results based upon LONG field.

"select test from all_data where test like 'AC%';"

"ERROR at line 1: ORA-00932: inconsistent datatypes "

Is there a way to accomplish this?