Re: How to do Case Insensitive Search using LIKE operator

Shekhar Kirani 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?
>
> Thanks,
>
> Shekhar Kirani
> http://www.starfishsoftware.com/
> --
> --------------------------------------------------------------
> Shekhar Kirani skirani_at_starfishsoftware.com

How bout:

select names from person
where upper(names) like upper('%sKi%')

It won't use an index on names if you have one but I think it gets what you are after. Received on Fri Oct 25 1996 - 00:00:00 CEST