contains

Returns true if a string expression field contains a specific substring, find.

Syntax

contains(string expr field, string find)

• field : string to search; an expression evaluating to string
• find : string to search field for evaluating to string

Returns

bool

Example

Determine which countries in a the vector of fields represented by SALES.COUNTRIES.COUNTRYNAME_ contains the ‘n’ character.

contains(SALES.COUNTRIES.COUNTRY_NAME, "n")

Notes

Function contains returns true when it finds find in expr and false otherwise.

Function contains is not case sensitive.