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