How to do Case Insensitive Search using LIKE operator
From: Shekhar Kirani <skirani_at_sprynet.com>
Date: 1996/10/24
Message-ID: <326FCBFA.2D8B_at_sprynet.com>#1/1
Date: 1996/10/24
Message-ID: <326FCBFA.2D8B_at_sprynet.com>#1/1
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.comReceived on Thu Oct 24 1996 - 00:00:00 CEST
