how do I deal with case sensitive data in Access?

S

sly135

I am trying to leverage SalesForce.COM ids in Access but the case sensitivity
is an issue. How can I work around matching a 16 alph-numeric case sensitive
unique identifier? I know there is a formula but I have not been able to
find it.
 
M

Michel Walsh

You cannot impose a constraint which will be case insensitive: a primary
key will only accept "a" or "A", but not both values, as example. Also,
GROUP won't differentiate "between "Aa", "aa", "AA and "aA"

You can still use StrComp for one to one comparison, though:


? StrComp("aAa", "Aaa", 0), StrComp("aAa", "aAa", 0),
StrComp("aAa", "aaa", 0)
1
-1


Vanderghast, Access MVP
 
Top