Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2001
    Posts
    3

    Unanswered: Non-case sensitive comparision

    Hi there!

    I got a new problem with Oracle running under Solaris.

    I would like to retrieve information giving the value of a column, so this is with: " select * where X = 'YYYY' ", but the where clause may ignore the case of the condition, so 'yyyy' will be as valid as 'YYYY' or 'YyYy'.

    Can anyone tell me how can I do it?

    Thanks in advance.

  2. #2
    Join Date
    Feb 2001
    Location
    NC, USA
    Posts
    200
    You need to use the lower() function, ie.
    Code:
    WHERE LOWER(XxX) = LOWER(XxX)
    If you have Oracle 9i, you can build a 'function based index' on this column to help performance. Of course, the best solution is to ensure the data is entered into the database in one case only at the start. This can be done with database triggers or through the application.

Posting Permissions

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