Re: case insensitive search.......how?

From: Christian Laliberté <claliberte_at_capitale.qc.ca>
Date: 2000/07/05
Message-ID: <l5K85.21678$NS6.318350@news.globetrotter.net>#1/1

Yes but if you have an index on the field name your index is not used to perform the select statement. When you have 300 000 records it can be very long.

Do you have another solution?

Christian

"Davide Bianchi" <davide_bianchi_at_usa.net> a écrit dans le message news: 8jphoe$146gu$1_at_ID-18487.news.cis.dfn.de...
> You can use something like
> SELECT.... WHERE NLS_UPPER(name) LIKE '%HELLO%'
> the NLS_UPPER function return the string in uppercase, this solve the
> case-sensitivity problem.
>
> Davide
>
>
> "I'm a good man" <goodman888_at_hongkong.com> wrote in message
> news:39603DDC.12C84A57_at_hongkong.com...
> > I have the value "Hello, I am a boy." in a field called "name" declared
> > as VARCHAR(255)
> >
> > I tried to do
> > SELECT * FROM table WHERE name LIKE '%hello%';
> >
> > but it returns zero row.
> >
> > and only
> > SELECT * FROM table WHERE name LIKE '%Hello%';
> >
> > returns 1 row.
> >
> > How to solve this?
> > --
> > Thanks and Regards,
> > Fung
> >
> >
>
>
Received on Wed Jul 05 2000 - 00:00:00 CDT