in

Returns true if specified string constants can be found in a given string.

Example

Determine whether the expression COUNTRYNAME_ evaluates to “Spain” or “Germany”.

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

Syntax

in(string expr field, string const1, string const2, …)

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

    Returns

    bool

Notes

Function in evaluates field then searches for the constants constN in the string. If any of constN are found, in returns true if at least one of the constN constants is found in field and false otherwise.


© Incorta, Inc. All Rights Reserved.