This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Is there a better way to perform a case-insensitive string comparison in a saved search than having a numeric formula criteria like `CASE WHEN UPPER({my_field}) = UPPER('find me') THEN 1 ELSE 0 END` ?
A recent database update caused UUID’s that were previously always being sent to NetSuite in upper case to suddenly all be lower case, so many searches are failing to find a match.

Could do something like this:

```CASE WHEN {my_field} = UPPER('find me') OR LOWER('find me') THEN 1 ELSE 0 END```
That way it doesn’t need to transform the whole column. But it could give you problems if you have mixed case in an entry.

I for some reason thought that plain criteria is case insensitive, but I might be wrong.

Could also try `LIKE` with ‘%’ around it. Or see if REGEXP_LIKE works.

```CASE WHEN regexp_like({name} , 'geever', 'i') THEN 1 ELSE 0 END```

<https://stackoverflow.com/questions/5391069/case-insensitive-searching-in-oracle>

Thanks!  I like the simplicity of the REGEXP_LIKE approach, I think I’ll give that a try.