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.


© Incorta, Inc. All Rights Reserved.