CONTAINS

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