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