Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003
    Posts
    1

    Unanswered: Case insensitive text search

    Hi..

    Is there a way of creating an Oracle-9i database, where all searches on text fields are case insensitive?

    Instead of having Where Upper(<Fieldname>) Like ...

    Many Thanks

    Shahine..

  2. #2
    Join Date
    Mar 2002
    Location
    Reading, UK
    Posts
    1,137
    I dont think you can do it globally. What you can do to improve performance is to index those text fields which are slow using for example upper(column) i.e. CREATE INDEX emp_i ON emp (UPPER(ename));

    Alan

Posting Permissions

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