473,378 Members | 1,372 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,378 software developers and data experts.

Equals Ignore case query

Hi All,

Is there any query in Oracle that will ignore the case with DB. I know there function in JAVA which ignore the case. Is there any feature same available in oracle.

For Example: I have ename in DB as "aBc" and in search query user is entering as "ABC". I need to get the details of ename="aBc". How can we achieve this?

Thanks,
Sreenath
Jul 17 '12 #1
2 4810
Rabbit
12,516 Expert Mod 8TB
Use the LCASE or LOWER function on both sides of the equivalency.
Jul 17 '12 #2
SELECT Ename FROM Db
WHERE UPPER(Ename)='ABC';
Jul 25 '12 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Mosas | last post by:
Dear All In Perl when we are checking some conditions using regular expression we can ignore the case sensitive of a string using the following regular expression /(^)|/|(\.\.)/i. But If I try...
15
by: YitzHandel | last post by:
The following is an extract from my program, which I seperated out and compiled as its own program. The problem is that as soon as a case tests true, all the cases below it execute as well. So...
2
by: Pierre | last post by:
Hello, I would like to write a regexp that can be either case sensitive or that can ignore the case based on a variable (value would be either 'i' or ''). For instance in the below code the...
4
by: Sarah | last post by:
is there a way to look at a string and ignore the case . i do not want to modify the string though. ie. i have a string and want to search for a substring "XYZ" but "XYZ" can be...
4
by: A.M | last post by:
Hi, How can I set the option of RegularExpressionValidator to RegexOptions.IgnoreCase ? Thanks, Alan
0
by: Morten71 | last post by:
I have this regex. in the ValidationExpression property of my dotnet 1.1 RegularExpressionValidator control: ^(?i)(DF)?+$ However, I can't make the ignore case part (?i) work! How should I...
2
by: Vinnie123 | last post by:
Is it possible to have mysql ignore the case when performing a search? I am making a user signup script. I want the usernames to be case sensitive (i.e. I do not want to store only lowercase...
3
by: rendfox | last post by:
I want to read a string and check it ignoring case and hyphens. if (string=='password'){ return true; } How can I make this true for PasS-WorD or P-A-Sswo-Rd or whatever?
5
by: tinnews | last post by:
Is there any way in python to say if string1 in string2: <do something> ignoring the case of string1 and string2? I know I could use:-
5
by: Evolution445 | last post by:
Hi, I currently have this code: If IO.File.Exists(txt_Path.Text & "\names.txt") Then SaveSetting("Search", "Main", "Found", "1") MessageBox.Show("Found names.txt") btn_Edit.Enabled =...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.