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

What is the function used in NS saved search for case insensitivity? Thanks!

MEMO, memo, MeMo, meMO, etc. Will be captured

Search filters are natively not case sensitive, so you shouldn't need a function to accomplish that.

I suppose if you wanted case sensitivity you could use a regular expression and a formula.

<@U0147J9JNJ3> Using a Case When Statement as an example... you can use the "Upper" function. Here is an example formula that ignores the case: CASE WHEN UPPER({status}) LIKE UPPER('paid in full') THEN {status} END

for this formula, PAiD iN fUlL, PAID IN FULL, paid in full, paid IN full, etc, etc would all be captured

The value is populated by a WF. NetSuite said that it is case sensitive.

It worked. thank you. Do you have a reference for this? I think there are a lot of functions that are not included in NS SA but are actually available when used in SS.

<@U0147J9JNJ3> If I need a function that doesn't show as a possible function to select on a saved search, I do a good old Google search for "Oracle SQL Functions"