CAPITAL And lower case Access recognition

[Guest]

I am unable to get Access to recognize a lower case t and a Capital T. I
need to delete one and keep the other. I must be missing something basic.

 

[Dirk Goldgar]

I am unable to get Access to recognize a lower case t and a Capital
T. I need to delete one and keep the other. I must be missing
something basic.

Text comparisons in Access are normally case-insensitive. You can use
the StrComp function to perform a binary comparison; for example,

DELETE * FROM MyTable
WHERE StrComp(MyField, "t", 0) = 0;

That should delete records where MyField = "t", but not where MyField =
"T".