Description
Returns a value indicating whether a column contains a given value in any row
Syntax
ColumnContains(<columntosearch>, <itemtofind>, [casesensitive])
Arguments
| Argument | Type | Description | Optional |
|---|---|---|---|
| columntosearch | Column Reference | Specifies a column to search | No |
| columntosearch | Column Reference | Specifies a column to search | No |
| itemtofind | Text | A piece of text to find | No |
| casesensitive | Yes/No | A flag indicating whether to perform a case sensitive search | Yes – Defaults to ‘False’ |
| Expression: | ColumnContains([Title], 'Fly Fishing', false) |
| Returns: | True |