Re: Help me please!!

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Wed, 16 Jun 2004 23:15:12 GMT
Message-ID: <4w4Ac.102739$3x.72692@attbi_s54>

"Susie" <susannahbrowning_at_lycos.com> wrote in message news:e090d470.0406160750.37da3293_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?
If it is a whole word then Intermedia. Else you have to uppercase (or lowercase) the two items and compare.
Jim Received on Wed Jun 16 2004 - 18:15:12 CDT