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

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
>> >
Received on Thu Jul 06 2000 - 00:00:00 CDT