Re: How to do Case Insensitive Search using LIKE operator

From: Roberto <rprendin_at_magi.com>
Date: 1996/10/25
Message-ID: <54pa44$qao_at_news.istar.ca>#1/1


try this:
 select names from person
   where UPPER(names) like '%'||'SKI'||'%'

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?
 

>Thanks,
 

>Shekhar Kirani
>http://www.starfishsoftware.com/
>--
>--------------------------------------------------------------
>Shekhar Kirani skirani_at_starfishsoftware.com
Received on Fri Oct 25 1996 - 00:00:00 CEST

Original text of this message