Contains

Returns true if a string contains a substring.

Usage

Contains(string, substring)

string (required) The text to search.

substring (required) The text to search with.

NOTE: Contains is case-sensitive. To create a search that is not case sensitive, you can combine Lower with Contains.

Example

Contains("Jane Doe", "ne D")

• Returns TRUE

Contains(Lower("Jane Doe"), "ne d")

• Returns TRUE

See Also

• StartsWith
• Find
• EndsWith