Re: How to do Case Insensitive Search using LIKE operator

In article <54qv32$10a_at_cortex.nlm.nih.gov>, wenk_at_tendon.nlm.nih.gov says...
>
> : Shekhar Kirani <skirani_at_sprynet.com> wrote:
 

> : >Hi:
 

> : >In ORACLE is it possible to make a case insensitive search
> : >on columns where columns contain case sensitive data?
 

> : >For example, suppose NAMES column contain 'JDoe', 'SKirani' and so on.
> : >How do I make a SQL like
> : >SELECT NAMES FROM PERSON WHERE NAMES LIKE %sKi%
> : >return the 'SKirani' row?
>
> You can do case-insensitive searching with the Context Option of 7.3.2
> which offers the "contains" clause. There's a fair amount of overhead
> involved but it does allow you to perform a case-insensitive search
> directly against the indices.

How about:

select names from person where upper(names) like '%SKI%';

Regards,
Bob

-- 

Bob Withers              Do or do not, there is no try.
bwit_at_pobox.com                                  Yoda
bwit_at_mo.net