Hello
When use SQL query agaisnt access DB it is NOT case sensitive for me.

example, lets say i have this record on the DB:

Name: Amir
Last Name: Gershman
Age: 27

Now i use this query against this table:

SELECT *
FROM Table_Name
WHERE Name = amIR

This WILL return me this record . i dont want this to come back,
I want it to be case sensitive.

How can i do it? please help .

btw - how is it working with sql server? what is the default? anything else i need to know?

Thanks ALOT.

Namo.