contains

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

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")

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

Notes

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

Function contains is not case sensitive.