Scalar FunctionsString Functions

contains_cs

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

Syntax

text contains_cs lookup

Negated form:

text !contains_cs lookup

Function call syntax:

contains_cs(text, lookup)

Prop

Type

Returns: bool

print "The Vikings raided York" contains_cs "York"

print_0 (bool)
true

contains

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

countof

Counts occurrences of a substring in a string.