case insensitive searches in MSACCESS

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Other Forums

MS Access

case insensitive searches in MSACCESS

Author

Topic

rum23
Yak Posting Veteran

77 Posts

Posted - 2008-10-20 : 09:49:56

I have MS ACCESS 2007 frontend application with SQLServer 2005 as the back end. Tables in ACCESS are linked tables (linked to SQLServer 2005 tables). Now, I want to perform case-insensitive searches. How can I accomplish this in ACCESS?

Right now, using queries in ACCESS, if I do

"SELECT * from tblEmployee Where FirstName Like ('%Mark%') - This returns 10 records as expected.

But, if I do
"SELECT * from tblEmployee Where FirstName Like ('%MARK%') - This returns 0 records. I want the query to return 10 records instead. How do I do this?

Thanks a ton for your help.

-rum23

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-10-20 : 10:02:27

One of the methods is
SELECT * from tblEmployee Where lcase(FirstName) Like lcase(('%Mark%'))

Madhivanan

Failing to plan is Planning to fail