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

From: Davide Bianchi <davide_bianchi_at_usa.net>
Date: 2000/07/03
Message-ID: <8jphoe$146gu$1@ID-18487.news.cis.dfn.de>#1/1

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 Mon Jul 03 2000 - 00:00:00 CDT