Letter casing is ignored when executing an SQL check through Batch Validate when the data is in a personal geodatabase.
Last Published: April 18, 2016No Product Found
Bug ID Number
September 3, 2014
September 22, 2022
No Product Found
No Version Found
After review by the development team, it has been determined that this issue is related to a known limitation with the software that lies outside of Esri's control. The issue's Additional Information section may contain further explanation.
This is expected behavior.
As stated in the help topic, 'Building a query expression' - Strings in expressions are case sensitive except when querying personal geodatabase feature classes and tables. To make a case-insensitive search in other data formats, use an SQL function to convert all values to the same case. For file-based data sources like file geodatabases or shapefiles, use either the UPPER or LOWER function.