Hello,

Kindly let me know how do I write a select query in Access so that criteria in where clause is case sensitive.

I tries like this Select * from tablename where description='Paris' . It returned those records also where the value was PARIS i.e. all letters were in upper case. I want that query should return records having a exact match.

Kindly advice.

Thanks

hi
i think this may help u.

u can use "like" key word in query. as such
Select * from tablename where description=%like% PER....