Home » SQL & PL/SQL » SQL & PL/SQL » Ignore case character wise
Ignore case character wise [message #211490] Thu, 28 December 2006 23:30 Go to next message
Messages: 3
Registered: December 2006
Junior Member
I need to match a given input string to a set of strings without considering the case of the characters of the input string.Like if the set of string is ('jan','feb','mar','apr') then all of the following input string should be acceptable 'Jan','FEb','MAR','aPR','apR' after comparision with
the set of string. So is this possible with any built-in function or otherwise?
Re: Ignore case character wise [message #211500 is a reply to message #211490] Fri, 29 December 2006 00:40 Go to previous message
Messages: 7880
Registered: March 2000
Senior Member
If you would have searched this forum you would have found many hits describing this same problem.
The simplest option is to use upper() on both sides of the equation.
Previous Topic: retrieve last access time for users from table
Next Topic: How to retrieve all the previous sql statements? (Merged)
Goto Forum:

Current Time: Wed Aug 16 08:23:50 CDT 2017

Total time taken to generate the page: 0.07007 seconds