Operators
A list of the operators you can use in custom or calculated expressions.
Operator | Description |
---|---|
-
Arg1
|
Negates the argument. The argument and the
result are of type
Real .
|
Arg1 +
Arg2
|
Adds the two arguments. See operator
& for
String concatenation.
|
Arg1 -
Arg2
|
Subtracts Arg2 from Arg1. |
Arg1 *
Arg2
|
Multiplies the two arguments. The arguments
and the result are of type
Real or
Decimal .
|
Arg1 /
Arg2
|
Divides
Arg1 by
Arg2. The arguments and the result are of type
Real or
Decimal . Division by zero results in an invalid
value.
Examples: 7/2 → 3.5 0/0 →
-1/0 →
|
Arg1 &
Arg2
|
Appends
Arg2 to the end of
Arg1. The arguments can be of any type, but are converted
to strings. The result is of type
String . See also function
Concatenate .
Examples:
|
Arg1 %
Arg2
|
Returns the remainder of the division of
Arg1 by
Arg2. The arguments and the result are of type
Real or
Decimal . Invalid values are propagated to the
result column.
Example:
|
Arg1 !=
Arg2
|
Returns true if Arg1 is not equal to Arg2. Examples:
|
Arg1^Arg2
|
Returns
Arg1 raised to the
Arg2 power.
Example:
|
Arg1 <
Arg2
|
Returns
true if
Arg1 is less than
Arg2. The arguments can be of any type, but must both be
of the same type. The result is of type
Boolean . If any argument is invalid, the result
is invalid. The function is defined for comparing normal numbers to each other.
Other combinations result in invalid values.
Examples:
|
Arg1 >
Arg2
|
Returns
true if
Arg1 is greater than
Arg2. The arguments are of type
Real and the result is of type
Boolean . See operator
< for the definition of valid arguments.
|
Arg1 <=
Arg2
|
Returns
true if
Arg1 is less than or equal to
Arg2. The arguments are of type
Real and the result is of type
Boolean . See operator
< for the definition of valid arguments.
|
Arg1 >=
Arg2
|
Returns
true if
Arg1 is greater than or equal to
Arg2. The arguments are of type
Real and the result is of type
Boolean . See operator
< for the definition of valid arguments.
|
Arg1 =
Arg2
|
Returns true if
Arg1 is equal to
Arg2. The arguments can be of any type, but must both be
of the same type. The result is of type
Boolean . If any argument is null, the result is
null. For arguments of type
Real , see operator
< for the definition of valid arguments.
Examples:
|
Arg1 <=>
Arg2
|
Returns true if the first argument is equal to the second argument or if both arguments are null. The arguments can be of any type, but must both be of the same type. The result is of type boolean. Example:
|
Arg1 <>
Arg2
|
Returns
true if
Arg1 is not equal to
Arg2. The arguments can be of any type, but must both be
of the same type. The result is of type
Boolean . If any argument is invalid, the result
is invalid. For arguments of type
Real , see operator
< for the definition of valid arguments.
|
Arg1 ~=
Arg2
|
Operator which can be part of an
IF or a
CASE statement. The arguments can be of any
type, but will be treated as string columns. Returns
true if the
Arg2 regular expression string matches the
Arg1 string.
Some characters, like for instance the backslash character
" Examples:
|
And(Arg1, ...)
|
Operator which can be part of an
IF or
CASE statement. It has two boolean expressions
as arguments and returns
true if both expressions are true.
Examples:
|
Not(Arg1)
|
Operator which can be part of an
IF or
CASE statement. It negates the boolean
expression given as argument.
Examples:
|
Or(Arg1, ...)
|
Operator which can be part of an
IF or
CASE statement. It has two boolean expressions
as arguments and returns
true if one of the expressions is true.
Examples:
|
Xor(Arg1,
...)
|
Can be part of an
IF or
CASE statement. It has two boolean expressions
as arguments and returns
true if exactly one of the expressions is true.
Examples:
|