Re: How to do Case Insensitive Search using LIKE operator
From: Dave Mausner <dmausner_at_brauntech.com>
Date: 1996/10/25
Message-ID: <54pbrn$h0a_at_client3.news.psi.net>#1/1
Date: 1996/10/25
Message-ID: <54pbrn$h0a_at_client3.news.psi.net>#1/1
In article <326FCBFA.2D8B_at_sprynet.com>,
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?
yes: force one or both sides of the LIKE equation to be upper or lower, as you require, using the eponymous functions. note that a case-blind indexed lookup will not be possible if the indexed values were not stored in one case. to simplify life, always index a value stored in just one case.
-- Dave Mausner, Consulting Manager, Braun Technology Group, Chicago.Received on Fri Oct 25 1996 - 00:00:00 CEST