Operators and Functions¶

multiply, divide

i * j / k

Arithmetic operators for numeric types only.

percent

i % j

Calculates i as a percent of j; numeric types only.

add, subtract

i + j - k

Arithmetic operators for numeric types only.

equal

i == j

Comparison operators for string, numeric, and date types.

not equal

i != j

less than

i < j

Comparison operators for numeric and date types only.

less than or equal

i <= j

greater than

i > j

greater than or equal

i >= j

IN set

i IN ('apples','oranges')

Sets can be of any type.

IN range

i IN (j:k)

Ranges must be numeric or date types.

NOT

NOT( i )

Boolean operators. Parentheses are required for NOT.

AND

i AND j AND k

OR

i OR j OR k

parentheses

()

Used for grouping.

startsWith

startsWith(i, 'prefix')

Comparison operators for strings.

endsWith

endsWith(j, 'suffix')

contains

contains(k, 'substring')

concat

concat(i, ' and ', j, ...)

Returns the string of all parameters concatenated.