# Contains

The **Contains** function searches for a specified substring in a text value. If the substring is found, the function returns `True`, otherwise it returns `False`.

### Syntax

```
Contains(string, substring...)
```

Function arguments:

|                  |                                                                                                                                                                                                                                                                                                                                                                                 |
| ---------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **string**       | <p>A text value or column of text values to search.</p><ul><li>Individual text value input (not column input) must be enclosed in parentheses. For example, <code>"My name is Bob"</code>.</li><li>Can only reference a column that contains text data.</li></ul>                                                                                                               |
| **substring...** | <p>One or more substrings or columns of substrings to search for in the text value.</p><ul><li>Individual substring input (not column input) must be enclosed in parentheses. For example, <code>"is Bob"</code>.</li><li>Multiple substrings must be input as separate arguments. For example, <code>"name", "is Bob"</code> or <code>\[ColumnA], \[ColumnB]</code>.</li></ul> |

### Notes

* Arguments are case sensitive. To bypass case sensitivity, use the [lower](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/text-functions/lower "mention") function to convert the arguments to lowercase as needed.&#x20;
* When the multiple substring arguments are included, the function returns `True` if at least one substring is found.

### Examples

#### Example 1

```
Contains("Welcome to Sigma", "to sig")
```

Returns `False` because "to sig" (with a lowercase 's') isn't a substring in "Welcome to Sigma."

#### Example 2

```
Contains(Lower("Welcome to Sigma"), "to sig")
```

Converts the **string** argument to all lowercase characters and returns `True` because "to sig" is found as a substring in "welcome to sigma."

#### Example 3

```
Contains([Station], [City])
```

Returns `True` when the city name (text value in the *City* column) is found as a substring in the station name (text value in the *Station* column). Otherwise, the function returns `False`.

<figure><img src="https://files.readme.io/e7e48ce-image.png" alt=""><figcaption></figcaption></figure>

#### Example 4

```
Contains([Product Name], "Digital Camera", "DSLR")
```

Returns `True` when either "Digital Camera" or "DSLR" is found as a substring in the product name (text value in the *Product Name* column). Otherwise, the function returns `False`.

<figure><img src="https://files.readme.io/75e89c27d56001f03235e6312bd885ca7f441ef4b736d603a4d7c5f2b4857fb6-contains3.png" alt=""><figcaption></figcaption></figure>
