Page tree
Skip to end of metadata
Go to start of metadata

Syntax

CONTAINS(<string or list>;<string>)

Description

Returns a Boolean value if the string contains the desired characters (2nd argument) or not. This operation is case sensitive. CONTAINS returns false if one of the arguments is <null>.

Examples

Column1 (string)

Contains

CONTAINS returns

United States"united states"false
United States"United"true
Germany"Germany"true
Germany"ger"false
United Kingdom"King"true
<null>"King"false
United Kingdom<null>false

If the data you are using in your CONTAINS() is a list format data field, the string used to evaluate the element must match the entire element.

Column1 (list)

Contains

CONTAINS returns

[United States, Germany]"United"false
[United States, Germany]"United States"true
[United States, Germany]"germany"false
[United States, Germany]"Ger"false
[United States, Germany]"Germany"true

If you have a list data type and want to be able to use the CONTAIN() like a string, you can use TOJSON(), as in the following example.

Column1 (list)

Contains

CONTAINS returns

Column1 TOJSON ()CONTAINS returns
[United States, Germany]"United"false["United States", "Germany"]true
[United States, Germany]"United States"true["United States", "Germany"]true
[United States, Germany]"germany"false["United States", "Germany"]true
[United States, Germany]"Ger"false ["United States", "Germany"]true
  • No labels