Contains

The Contains keyword can be used on either Texts, Concept Sets or Lists.

It checks if a text, a concept set or a list contains a value (of corresponding type).

This function is PARTIALLY SQL compatible:

• the variant concept_set contains concept_set is NOT SQL compatible

For more information about SQL compatibility, see our documentation.

Returns a Yes/No value that indicates if the searched item is indeed part of the source being searched.

Text functions are not case-sensitive and ignore diacritics (accents).

text contains text

"With tangerine trees and marmalade skies" Contains "marmalade" => Yes

concept_set contains concept_b

{ 'PowerUser', 'Administrator' } Contains 'Administrator' => Yes

concept_set contains concept_set

{ 'User', 'PowerUser', 'Admin' } contains { 'User', 'Admin' } => Yes

{ 'PowerUser', 'Admin' } contains { 'User', 'PowerUser' } => No (the second set is not contained entirely within the first set, although there is overlap - which is a different keyword/function)

This variant will always have to be executed outside SQL context - it is not SQL compatible.

list contains item

list(1, 2, 3) contains 2 => Yes

list("A", "B", "C") contains "B" => Yes