Skip to main content



Contains Function

Determines if a text string or expression contains another text string or expression.

Syntax 1​

Contains(string, searchValue)

Determines if a text string or expression contains another text string or expression.

Arguments​

string String - A string.

searchValue String - A string.

Syntax 2​

Contains(string, searchValue, caseSensitive)

Determines if a text string or expression contains another text string or expression.

Arguments​

string String - A string.

searchValue String - A string.

caseSensitive Boolean - True for a case-sensitive search. If omitted, false (case-insensitive search) is used.

Remarks​

Example:

Contains("Ship to Wyoming", "Illinois"); // returns false

Example:

Contains("Ship to Illinois", "Illinois"); // returns true

Example:

Contains("Ship to Illinois", "illinois"); // returns true

Example:

Contains("Ship to Illinois", "illinois", true); // returns false