Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

Oracle select case sensitive

  • 16-07-2007 12:49PM
    #1
    quinnd6
    Registered Users, Registered Users 2 Posts: 1,559 ✭✭✭


    Hi
    Im sending a select sql statement to oracle using sql plus.

    Im searching for a certain word and if it doesnt exist in the table then an error comes up.

    Problem is it is case sensitive.

    How can I make it so it ignores the case?


Comments

  • #2
    is_that_so
    Registered Users, Registered Users 2 Posts: 32,132 ✭✭✭✭is_that_so


    quinnd6 wrote:
    Hi
    Im sending a select sql statement to oracle using sql plus.

    Im searching for a certain word and if it doesnt exist in the table then an error comes up.

    Problem is it is case sensitive.

    How can I make it so it ignores the case?

    You can always wrap the variable using lower
    For example
    select address,id from table where lower(inputname)=lower(table.name);


  • #3
    stipey
    Registered Users, Registered Users 2 Posts: 273 ✭✭stipey


    I find that google is good for these types of questions. You will probably get an answer quicker than waiting for somebody to read and respond to your post.

    Also, Oracle have excellent documentation on their website - oracle.com


Advertisement