
This Access tutorial explains how to use Access StrComp Function to compare text, both case sensitive and case insensitive comparison.
You may also want to read:
Access Case Sensitive Join Table (Inner Join, Left Join)
Access StrComp Function to Compare text (case sensitive comparison)
In Microsoft Excel, you cannot perform case sensitive comparison directly using equal sign. For example, if you type formula
="A"="a"
The formula returns TRUE. Vlookup also shows matching result even tho...
Read More