Scalar FunctionsString Functions

contains

Indicate whether a string contains another string (case-insensitive).

Syntax

text contains lookup

Negated form:

text !contains lookup

Function call syntax:

contains(text, lookup)

Prop

Type

Returns: bool

print "Ragnar sailed to Lindisfarne" contains "lindisfarne"

print_0 (bool)
true

String Operators

Infix string operators for filtering and matching

contains_cs

Indicate whether a string contains another string (case-sensitive).