CONTAINS_IC

Syntax

Description

Returns a Boolean value if the string contains the desired characters (2nd argument) or not. This operation isn't case sensitive, since IC stands for "ignore case". CONTAINS_IC returns false if one of the arguments is <null>.

Examples

Column1	Column2	CONTAINS returns
United States	united states	true
United States	Unitet	false
Germany	Germany	true
Germany	ger	true
United Kingdom	Kind	false
null	Kind	false