Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

SQL IGNORE CASE STATEMENT

Posted on 2005-04-12
2
Medium Priority
?
37,226 Views
Last Modified: 2012-06-21
Hi all,

Quite a simple on really, just gave it 500 for quick response.


I'm after a Oracle SQL command such as the following:

select *
from table1
where IGNORE CASE (field1 != field2);
0
Comment
Question by:trickys77
2 Comments
 
LVL 78

Accepted Solution

by:
slightwv (䄆 Netminder) earned 2000 total points
ID: 13764219
select *
from table1
where lower(field1) != lower(field2);

Depending on the size of the table you might need to look at a function based index.
0
 

Author Comment

by:trickys77
ID: 13764287
yep that works,

thanks
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
Suggested Courses
Course of the Month21 days, 6 hours left to enroll

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question