Comparing fields case sensitive PLEASE HELP

I have a access database with 2 identical tables.
The first called "prod" and the other called "prod_mirror" I use the field key as primary key. I want to select data changes between the tables and I use this query:

SELECT prod.* FROM prod, prod_mirror WHERE prod.key = prod_mirror.key AND prod.name <> prod_mirror.name

It works great but its not case sensitive, fo example if I just change a "b" to a "B" it does not see that as a differens.
Does anyone have any ideas how to get this work? I have heard somthing about "Option Compare Binary"

use a scalar function ;)
Scalar functions operate against a single value, and return a single value based on the input value.

Useful Scalar Functions in MS Access
Function Description
UCASE(c) Converts a field to upper case
LCASE(c) Converts a field to lower case
MID(c,start[,end]) Extract characters from a text field
LEN(c) Returns the length of a text field
INSTR(c) Returns the numeric position of a named character within a text field
LEFT(c,number_of_char) Return the left part of a text field requested
RIGHT(c,number_of_char) Return the right part of a text field requested
ROUND(c,decimals) Rounds a numeric field to the number of decimals specified
MOD(x,y) Returns the remainder of a division operation
NOW() Returns the current system date
FORMAT(c,format) Changes the way a field is displayed
DATEDIFF(d,date1,date2) Used to perform date calculations


Check this : http://www.w3schools.com/sql/sql_functions.asp