List:General Discussion« Previous MessageNext Message »
From:Paul Nowosielski Date:September 15 2008 12:10pm
Subject:make In statement non case sensitive?
View as plain text  
Hello,

Is there a way to call an IN statement
and have return results that are not case sensitive.


SELECT name FROM name_table WHERE name IN ('joe','john','harry')

would return the same as

SELECT name FROM name_table WHERE name LIKE 'joe' OR name LIKE 'john' OR name LIKE 'harry'

Thank you,

Paul



      
Thread
make In statement non case sensitive?Paul Nowosielski15 Sep
  • Re: make In statement non case sensitive?Jonathan Selander15 Sep
  • Re: make In statement non case sensitive?Dan Nelson15 Sep
    • Re: make In statement non case sensitive?Bard Aase15 Sep
      • RE: make In statement non case sensitive?Jerry Schwartz15 Sep
        • Re: make In statement non case sensitive?Bard Aase15 Sep