Re: Searching CLOBS case insensitive

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Thu, 19 Dec 2002 08:26:27 +1100
Message-ID: <WA5M9.5938$jM5.17040@newsfeeds.bigpond.com>

Probably not what you're after, but:

SQL> create table clobtest (
2 col1 clob);
Table created.
SQL> insert into clobtest values ('I am a CLOB'); 1 row created.
SQL> commit;
Commit complete.

SQL> select * from clobtest where upper(col1) like '%AM%';

COL1

I am a CLOB

Regards
HJR "Petri" <Petri33_at_hotmail.com> wrote in message news:b4803f2d.0212181312.2dcc4fde_at_posting.google.com...
> I am trying to search a CLOB field case insensitively. I am currently
> using dbms_lob.instr() but this function is case sensitive. Does
> anyone know how to search case insensitively?
Received on Wed Dec 18 2002 - 15:26:27 CST