Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2011
    Posts
    28

    Unanswered: Case insensitive data query

    Hi,

    I have in table Person, having column Name, where data is like,

    JOHN
    john


    When I am executing the SELECT Query on the name column,

    SELECT * FROM PERSON WHERE NAME = 'john';

    I am getting result corresponding to small letters john and not JOHN.

    How I should create query so that I will get both results.

    Thanks all.

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Use:

    Code:
    select * from person where lcase(name) = 'john'
    Do not expect it to perform well.

    Andy

Tags for this Thread

Posting Permissions

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