DB case sensitivity in Select statements and Comparisons

I have an issue where we have a vendor developing an application for us that casually mentioned that all users will have to always type everthing in upper case in order for them to get around cases sensitive searches in the DB. The cause of this is the application is designed for SQLServer/Access which is not case sensitive. I found away to turn off case sensitivity at the DB level, now I am being asked to provde a way at the statement level if that is possible. We are aware of the quick and dirty background case conversion but that is not really flexible enough