How do I get case sensitivity in a Matches Pattern query filter?
Hello! This is a follow up to a previous question I had about wild cards. I was able to get that working but, now I'm having an issue with case sensitivity not doing what I want in the query filter.
I have this so far "[Addy1] Matches Pattern %a%". What I need it to do is look anywhere in the field for a lower case a. What it's doing is pulling any field that has an A or an a in it.