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
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