EX case sensitivity

Question

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------------------------------

MarkShnierYou · Answer

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
------------------------------

Sign up

Login to the community