Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Posts
    51

    Unanswered: SQL case sensitive problem

    Hi all ,

    This is a table in oracle.

    NAME_TABLE
    -----------------
    No Name
    -----------------
    1 Abi
    2 ABI
    3 abi
    4 BINU
    5 CINU
    -----------------

    For the query : SELECT NAME FROM NAME_TABLE WHERE NAME='Abi';

    The out put is :
    No Name
    -----------------
    1 Abi


    In Oracle, Is there any single query(SQL) to get an output below : ?

    No Name
    -----------------
    1 Abi
    2 ABI
    3 abi


    thanks in advance .

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    SELECT NAME FROM NAME_TABLE WHERE UPPER(NAME)='ABI';

    If you have an index on NAME that query can't use it, so you might want to consider adding a function-based index on UPPER(NAME).

  3. #3
    Join Date
    Dec 2003
    Posts
    51
    thanks andrewst .. thanks a lot .

Posting Permissions

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