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("abc", LEFT([Name], 1)) answers the question: is the left-most character of the value of the Name an a, b, or c? Equivalent to IN(LEFT([Name], 1), {"a", "b", "c"}).

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