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), {".", "?", "!"})
.
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 intext-to-search
.