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_at_attbi_s54>
Date: Wed, 16 Jun 2004 23:15:12 GMT
Message-ID: <4w4Ac.102739$3x.72692_at_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 Thu Jun 17 2004 - 01:15:12 CEST