Difference between revisions of "CONTAINS"
From AgileApps Support Wiki
imported>Evelyn m |
imported>Aeric |
||
| Line 4: | Line 4: | ||
CONTAINS(text, compare_text) | CONTAINS(text, compare_text) | ||
{{:Common:CaseSensitiveSearchString}} | |||
;Return:TRUE or FALSE | ;Return:TRUE or FALSE | ||
Revision as of 00:52, 4 June 2014
The CONTAINS function determines whether a given text string contains another text string. If the text string contains the compare_text string, this function returns TRUE. If the text string does not contain the compare_text string, this function returns FALSE.
- Syntax
CONTAINS(text, compare_text)
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