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 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)

list contains item

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

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

Last updated