Differences in CLOB search returns

I have noticed that if you use dbms_lob.instr() (ex: select * from table where dbms_lob.instr(CLOB_COL, 'search criteria')>0) you return more hits then if you use CONTAINS() with the Intermedia/Context Cartridge (ex: select * from table where CONTAINS(CLOB_COL, '%search criteria%')>0).

I would think that the second statement would return more hits. Does anyone know why it doesn't?

Thanks. Received on Fri Aug 22 2003 - 13:41:30 CDT