Skip to Content
avatar image
Former Member

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.

Any suggestions?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Sep 17, 2014 at 11:05 PM

    Hi Amanda,

    You could use the pattern _%a% which would eliminate records starting with A.

    Regards

    Sri Harsha

    Add comment
    10|10000 characters needed characters exceeded

    • From what I can see (XI3.x), the pattern matching query filters are case insensitive. For case sensitivity, use the MATCH function in the report, e.g.:

      =Match([Customer];"*a*")

      ..returns TRUE (1) for Customer "Cabinet".

      =Match([Customer];"*A*")

      ..returns FALSE (0) for Customer "Cabinet", but TRUE for Customer "CABINET".

      HTH

      NMG

  • avatar image
    Former Member
    Sep 18, 2014 at 12:02 PM

    As Neil already suggested about the case sensivity at theĀ  report end.

    Another approcah is use custom query option and modify the sql to incorparte above condition.

    Regards,

    Pranay

    Add comment
    10|10000 characters needed characters exceeded