How to I write a SQL query to ignore case in a Oracle database?

435865 pts.
Tags:
Oracle Database
SQL Query

In my Oracle database, I have a SQL query that I want to ignore case. See below:

SELECT * FROM TABLE WHERE TABLE.NAME Like 'IgNoReCaSe'

So if I want the query to return either "IGNORECASE", "ignorecase" or a combination of them, how can I do that? Would that be possible?

Answer Wiki

Thanks. We'll let you know when a new response is added.

This should be enough:

SELECT * FROM TABLE WHERE upper(TABLE.NAME) = 'IGNORECASE';

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Genderhayes
    Unzip the downloaded file try database connection using Oracle SQL developer 3.0
    9,890 pointsBadges:
    report
  • carlosdl
    Genderhayes, What are you talking about?

    Don't mean to be rude, but I am really having a hard time figuring out whether you are actually a person or a bot.  Most of the comments and answers you post are non-sense, completely unrelated to what is being asked.
    79,775 pointsBadges:
    report
  • Michael Tidmarsh
    Genderhayes, can you give more information on your answer?
    48,375 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: