Re: Contains and case insensitive

"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 Received on Fri Sep 21 2001 - 03:31:36 CDT