Re: How to do Case Insensitive Search using LIKE operator

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 should be able to do the following:

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

>Thanks,
 

>Shekhar Kirani
>http://www.starfishsoftware.com/
>--
>--------------------------------------------------------------
>Shekhar Kirani skirani_at_starfishsoftware.com

Frank Thomas
thomasf_at_daugherty.com Received on Fri Oct 25 1996 - 00:00:00 CEST