CONTAINS

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