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 |