Re: Contains and case insensitive

From: TurkBear <noone_at_nowhere.com>
Date: Fri, 21 Sep 2001 08:56:10 -0500
Message-ID: <dkhmqtoaglkujip1qgd9kae14li5c0l622@4ax.com>

Its actually
select * from table where contains( upper(text),'HALLO') and if you are using 8i, you can use a function-based index for the UPPER function and it will be used.. See the 8i docs..

"Davide Bianchi" <davidebianchi_at_davidebianchi.net> wrote:

>"Oliver Huppert" <Oliver.Huppert_at_pikon.com> wrote in message
>news:9oesg4$l8j$1_at_piesbach.saarnet.de...
>> Someony knows what I could do??
>
>select * from table where contains(to_uppercase(text), 'HALLO')
>
>(or was to_upper ?)
>
>Note: this way Oracle will *not* use any index during
>the search, slowing down considerably.
>
>Davide
>
>

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! Check out our new Unlimited Server. No Download or Time Limits! -----== Over 80,000 Newsgroups - 19 Different Servers! ==----- Received on Fri Sep 21 2001 - 08:56:10 CDT