|
Q.
ODBC Case Insensitive passwords: I use Access as a database, and the username
lookup is case insensitive which I like.
How do I get the password to be case insensistive too? A. Goto the Options/ODBC dialog and unset the Case Sensitive checkbox. Also, this is an interesting MSSQL statement which may be of assistance:
SELECT * FROM PHONE WHERE {fn UCASE(LAST)} LIKE 'URWILER%'
|
|