make In statement non case sensitive?

[Paul Nowosielski]

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