Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2010
    Posts
    10

    Unanswered: case insensitive search

    how case insensitive search is done.
    like in table there are
    "a"
    "A"
    then both should come when condition is ="a"

  2. #2
    Join Date
    Jan 2010
    Posts
    18
    Quote Originally Posted by lodha13 View Post
    how case insensitive search is done.
    like in table there are
    "a"
    "A"
    then both should come when condition is ="a"
    I haven't used informix. But if it is case sensitive in the matching (like Oracle is) then you need to shift everything to the correct case.

    So if you want to see if everything starts with 'A' and 'a' then it's something like:

    select * from <table> where upper(columnname) like 'A%'

    If you're comparing against a variable, it's more or less the same:

    select * from <table> where upper(columnname) = upper(varname).


  3. #3
    Join Date
    Aug 2006
    Location
    The Netherlands
    Posts
    248
    Or use the MATCHES operator with the regular expression like operand:
    Code:
    WHERE column MATCHES '[Ss][Tr][Ii][Nn][Gg]'
    Regards,
    Hans

Posting Permissions

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