So I have a Personal Geodatabase in ArcGIS 10.0 where I ended up with some attribute values that are almost the same, but not exactly. The difference is that there's one bunch of features saying "other" and another one saying "Other" (and they're actually subtly different, I messed up, I know that's bad...)
When I tried to select [value] = 'other' it returned both sets of features. Turns out that ArcGIS is only doing case insensitive selections in Personal Geodatabases. Seriously ESRI?
Funny enough the symbolisation is working case sensitive!
Any suggestion on how I can get around this?