Difference between revisions of "CONTAINS"
From AgileApps Support Wiki
imported>Aeric |
imported>Aeric |
||
| Line 1: | Line 1: | ||
The CONTAINS function determines whether a given text string contains another text string. If the text string contains the | The CONTAINS function determines whether a given text string contains another text string. If the text string contains the search string, this function returns TRUE. If the text string does not contain the search string, this function returns FALSE. | ||
;Syntax: | ;Syntax: | ||
CONTAINS( | CONTAINS('string', 'searchString') | ||
{{:Common:CaseSensitiveSearchString}} | {{:Common:CaseSensitiveSearchString}} | ||
Latest revision as of 00:54, 4 June 2014
The CONTAINS function determines whether a given text string contains another text string. If the text string contains the search string, this function returns TRUE. If the text string does not contain the search string, this function returns FALSE.
- Syntax
CONTAINS('string', 'searchString')
Note:
The searchString is case-sensitive. For a case-insensitive search,
use the LOWER function on both the search string and the string being searched.
- Return
- TRUE or FALSE
- Examples
CONTAINS('streetlamp', 'lamp') = TRUE
CONTAINS('streetlamp', 'streets') = FALSE