Difference between revisions of "CONTAINS"
From AgileApps Support Wiki
imported>Evelyn m |
imported>Aeric |
||
| (One intermediate revision by the same user not shown) | |||
| 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}} | |||
;Return:TRUE or FALSE | ;Return:TRUE or FALSE | ||
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