Q: Case insensitive search

I believe Access is case insensitive, but most other real DBs are case sensitive. Now, say a user searches for column "device" and the column is stored as "Device" in the DB, they will NOT match. How do I make them match? Is there any easier way than converting everything to upper string?

I suppose converting all to upper case is easy enough, but I think something like select IgnoreCase * from table would still be beneficial.

The use of a function on the right hand side in a where clause will force the optimizer to not use an index if one is present.
...
Access is case insensitive. A query like this:
select *
from zoo
where animal like 'tiger'
...
Will yield all derivations of tiger.