Re: Case-INSENSITIVE searches?? Possible??

I suggest creating a function based index to handle things. Let the searches go against that index. Then your not calling the lower function all the time.

John Peterson wrote:

> Hello, Steve!
>
> Would you also want to process the ename field with the UPPER function as
> well (for consistency's sake)?
>
> Also, is there any other way to do a case-insensitive search? I've got a
> dynamic query that has quite a few strings that are being searched, and the
> DML is "littered" with a ton of calls to LOWER. I'm sure that's not the
> most optimal, but...
>
> "Steve Bell" <swayne.bell_at_sympatico.ca> wrote in message
> news:3AC33724.877A401_at_sympatico.ca...
> > Hi Alex,
> >
> > Another poster has answered that you can use UPPER or LOWER row functions
> > to do this. I'll elaborate a bit with an example:
> >
> > SQL> select ename from emp
> > 2 where ename like UPPER('bla%');
> >
> > ENAME
> > --------------------
> > BLAKE
> > BLAKESON
> > BLAKESMITH
> > BLAKESONSMITH
> >
> > SQL>
> >
> > Hope this helps,
> > Steve
> >
> > Alex Skolnic wrote:
> >
> > > How can I perform a case-insensitive search?
> > >
> > > I trying to perform a search on any portion of a description field
> > > that can be entered in Mixed case. My SQL statement is using the LIKE
> > > '%search%' statement, but it won't return matches that don't have the
> > > same case.
> > >
> > > Any ideas?
> >
  Received on Thu Mar 29 2001 - 09:10:39 CST