Built-in Functions → in

in() is a boolean function that returns true if the specified string constants can be found in a given string, otherwise, it returns false.

Signature

in(find exp, const1, const2, ...)

  • find : string expression to search
  • const : string constants to search for in find

Returns

bool

Example

Determine whether the expression COUNTRY_NAME evaluates to "Spain" or "Germany".

in(SALES.COUNTRIES.COUNTRY_NAME,"Germany", "Spain")