Is there any quick and easy way to make query.runSuiteQL LIKE queries case insensitive?
s
scottvonduhn
06/16/2022, 3:43 PM
I haven’t tested this, but you could try to use the Oracle REGEXP_LIKE instead of LIKE, which has a third parameter where you can specify case insensitive matching:
REGEXP_LIKE({field}, pattern, 'i')
d
Dominic B
06/16/2022, 4:01 PM
Thanks Scott. Not working at the moment, but not erroring either. Will investigate if its just a regex issue tomorrow with a clearer head!