How to perform a case insensitive string search using a Lotus SQL ODBC connection?

What's the correct syntax for t开发者_StackOverflowhis equivalent TSQL query? SELECT * FROM MyTable WHERE LOWER(Name) = LOWER ("MixedCaseInput")