Re: How to do Case Insensitive Search using LIKE operator
From: Christine Wenk <wenk_at_tendon.nlm.nih.gov>
Date: 1996/10/25
Message-ID: <54qv32$10a_at_cortex.nlm.nih.gov>#1/1
Date: 1996/10/25
Message-ID: <54qv32$10a_at_cortex.nlm.nih.gov>#1/1
: 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. Received on Fri Oct 25 1996 - 00:00:00 CEST