Searching a CLOB Case Insensitively

From: Petri <Petri33_at_hotmail.com>
Date: 18 Dec 2002 13:16:23 -0800
Message-ID: <b4803f2d.0212181316.6546a36d_at_posting.google.com>


I'm trying to search a CLOB field Case insensitively. I'm currently using dbms_lob.instr() to search, but this function is case sensitive.  Does anyone have an idea on what I can use here? Received on Wed Dec 18 2002 - 22:16:23 CET

Original text of this message