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
