Forum Discussion

FrancescoGallar's avatar
Qrew Member
2 years ago

EX case sensitivity

While searching for data through the API I realized that the EX query is case sensitive.
In my specific table, this returns nothing:


while this returns a record:

"{'6'.EX.'John Davis Llc'}"

Is there a way make a search non-case sensitive?

// Francesco

Francesco Gallarotti

2 Replies

  • The low tech way would be to create a new field called [Company Upper Case] with a formula of

    Then the .EX. will work as everything will be in upper case.  That Upper function does not change numbers or special characters so it's safe.

    Mark Shnier (YQC)
    • JeffPeterson1's avatar
      Qrew Captain
      I think you can use CT (contains) instead of EX (exactly) as well.

      Jeff Peterson