Forum Discussion

FrancescoGallar's avatar
FrancescoGallar
Qrew Member
3 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:

"{'6'.EX.'JOHN DAVIS LLC'}"


while this returns a record:

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

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

// Francesco

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

    Upper([Company])
    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)
    mark.shnier@gmail.com
    ------------------------------
    • JeffPeterson1's avatar
      JeffPeterson1
      Qrew Captain
      I think you can use CT (contains) instead of EX (exactly) as well.

      ------------------------------
      Jeff Peterson
      ------------------------------