CONTAINS

Returns true if the first string contains the second string.

Usage

CONTAINS(text, match, ignoreCase)

text	String	The string that may contain the string to seek.
match	String	The string to seek.
ignoreCase	Boolean	True if search ignores the case.

Boolean

CONTAINS(‘HELLO Everyone’, ‘he’, false)	false
CONTAINS(‘HELLO Everyone’, ‘hE’, true)	true
CONTAINS(‘HELLO Everyone’, ‘HE’, false)	true
CONTAINS(‘HELLO Everyone’, ‘HE’, true)	true

N/A