Scalar FunctionsString Functions

countof

Counts occurrences of a substring in a string.

Syntax

countof(source, search, kind)

Prop

Type

Returns: long

print countof("Ragnar raided Lindisfarne and raided York", "raided")

print_0 (long)
2

print countof("Ragnar raided Lindisfarne in 793 and York in 866", "[0-9]+", "regex")

print_0 (long)
2

contains_cs

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

endswith

Indicate whether a string ends with another string (case-insensitive).