Learn more
Filters and Case Sensitivity (Database Editor)
If you want a text operator to filter based on text case, click the button when setting up the filter in the Edit Filter window.
Note: When Match case is turned on, uppercase letters sort after lowercase letters. For example, if you filter for the word "Excavation," the <= operator finds everything below "Excavation" including "excavation." If you filter for "excavation," it will not find "Excavation."