Results 1 to 2 of 2

Thread: Ignore CASE

  1. #1
    Join Date
    Sep 2003
    Location
    The extremely Royal borough of Kensington, London
    Posts
    778

    Unanswered: Ignore CASE

    Hey,

    Anybody know how to ignore CASE sensitivety in sql statements

    table1.c1 = 'abc' and table2.c1 = 'ABC' i need these to match

    cheers.

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: Ignore CASE

    I believe some DBMSs let you "turn off" case sensitivity. In Oracle you can't do that, you would have to change the query to e.g.:

    UPPER(table.c1) = 'ABC'

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •