CAPITAL And lower case Access recognition

K

Keith

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.
 
D

Dirk Goldgar

Keith said:
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.
Click to expand...

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".
 
Top