CONTAINS()

Returns a Yes/No expression, as follows:

• TRUE if the text fragment is found in the search value.
• FALSE if the text fragment is not found in the search value.

Note: The search is case-insensitive: upper- and lower-case letters are equivalent.

Sample usage

CONTAINS("abc", "a") returns  TRUE

CONTAINS("abc", "bc") returns TRUE

CONTAINS("abc", "d") returns FALSE

CONTAINS("I'm bored!", "Red")  returns TRUE

CONTAINS([Address], "PO Box") answers the question: does the Address indicate a post office box?

CONTAINS([Email], "@") answers the question: does the Email contain at least one at sign (@)?

CONTAINS(".?!", LEFT([Sentence], 1)) answers the question: is the left-most character of the value of the Sentence (LEFT([Sentence], 1)) a period (.), question mark (?), or exclamation mark (!) (".?!")? Equivalent to IN(LEFT([Sentence], 1), {".", "?", "!"}).

See also: LEFT(), IN()

Syntax

CONTAINS(text-to-search, text-to-search-for)

• text-to-search - Text to be searched.

• text-to-search-for - Text string to search for in text-to-search.

See also

ENDSWITH()

FIND()

IN()

STARTSWITH()