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 |