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

346080 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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Genderhayes
    Unzip the downloaded file try database connection using Oracle SQL developer 3.0
    7,440 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.
    69,410 pointsBadges:
    report
  • Michael Tidmarsh
    Genderhayes, can you give more information on your answer?
    30,440 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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following