Correct. You can't do functions on LONG datatypes. One of the many restrictions. Dean Warden, Matt writes: > >can you force it to a case-insensitive search by wrapping the column > >reference with a Lower() function? for example: > > > >DBMS_LOB.INSTR(Lower(column), '#LCase(search_string)#') <> 0 > > no, i tried that a few days ago when i was playing around with > dbms_lob on the test db. it gives an invalid type message of some > sort. I guess you can't use LOWER() on that type of field.