Skip to Content
0
Former Member
Sep 17, 2014 at 08:10 PM

How do I get case sensitivity in a Matches Pattern query filter?

1207 Views

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.

Any suggestions?