Select Page

Returns true if a string contains a substring.


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.


Contains(“Jane Doe”, “ne D”)
  • Returns TRUE
Contains(Lower(“Jane Doe”), “ne d”)
  • Returns TRUE

See Also


More About Text Functions

Text functions analyze or manipulate string data and are useful sanitizing string input.

When inputting a string, use quotation marks to indicate it as a string. “This is read as a string”

If you would like to include quotes in your string, you can use a slash \ to indicate the following quote is part of the string. “\”This is a string with quotes\”” will display as “This is a string with quotes”

We are rewriting the rules of analytics. Sigma empowers domain experts to join the data conversation, answer the toughest questions, and drive insights.