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

Another option is the OMNIDEX database search engine from DISC. See http://www.disc.com/keyword.html or contact me.

Cheryl Grandy
cgrandy_at_disc.com
303 444-4000
www.disc.com/home

In article <20000705201306.24618.00001170_at_ng-fz1.aol.com>,   timkarnold_at_aol.com (TimKArnold) wrote:
> interMedia (formerly ConText)
>
> >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
> >> >
>
>

--
Cheryl Grandy
DISC
Get OMNIDEX for the fastest
applications ever


Sent via Deja.com http://www.deja.com/
Before you buy.