Find a substring in CLOB case insensitevly

From: <tkarakai_at_my-deja.com>
Date: Fri, 29 Oct 1999 18:01:19 GMT
Message-ID: <7vcndc$3pa$1@nnrp1.deja.com>

I store long text documents in CLOB fields. How can I tell if a CLOB contains a certain string, but in a case insensitive way? (Basically implementing a search feature). Dbms_lob.instr() is case sensitive....

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Oct 29 1999 - 13:01:19 CDT