Operators
Modulo (%)
Syntax:number_1 % number_2
Returns the remainder from dividing the first number number_1
by the second number number_2
.
Multiplication (*)
Syntax:value_1 * value_2
If both arguments are numbers, it returns the result by multiplying value_1
by value_2
.
If one of the arguments is String
and the other is Integer
, it returns the string repeated the specified number of times.
Addition and concatenation (+)
Syntax:value_1 + value_2
Behaves differently depending on the argument types. Possible options are listed in the table:
Type of value_1 |
Type of value_2 |
Return value |
---|---|---|
Fractional number | Integer |
Fractional number | Integer |
The sum of the numbers value_1 and value_2 . |
Date |
Fractional number | Integer |
The date that is value_2 days greater than value_1 (rounded down to an integer number of days). |
Datetime |
Fractional number | Integer |
The date with time, value_2 days greater than value_1 . If value_2 contains a fractional part, it is converted hours (1/24 ), minutes (1/1440 ), and seconds (1/86400 ). |
String |
String |
The merging (concatenation) of strings value_1 and value_2 . |
Array of fractional numbers | Array of integers | Array of strings |
Array of fractional numbers | Array of integers | Array of strings |
The merging (concatenation) of arrays value_1 and value_2 . |
Changing the order of arguments does not affect the result.
Subtraction (-)
Syntax:value_1 - value_2
Behaves differently depending on the argument types. Possible options are listed in the table:
Type of value_1 |
Type of value_2 |
Return value |
---|---|---|
Fractional number | Integer |
Fractional number | Integer |
The difference between the numbers value_1 and value_2 . |
Date |
Fractional number | Integer |
The date that is value_2 days smaller than value_1 (rounded down to an integer number of days). |
Datetime |
Fractional number | Integer |
The date with time, value_2 days smaller than value_1 . If value_2 contains a fractional part, it is converted to hours (1/24 ), minutes (1/1440 ), and seconds (1/86400 ). |
Date |
Date |
The difference between two dates in days. |
Any |
Any |
The difference between two dates in days: the integer part — the number of whole days, the fractional part — the number of hours, minutes and seconds expressed as a fraction of the whole day (1 hour is '1/24'). |
Datetime |
Datetime |
The difference between two dates in days: the integer part — the number of whole days, the fractional part — the number of hours, minutes and seconds expressed as a fraction of the whole day (1 hour is '1/24'). |
Division (/)
Syntax:number_1 / number_2
Divides the number number_1
by the number number_2
.
Comparison
Syntax:value_1 = value_2
orvalue_1 != value_2
orvalue_1 < value_2
orvalue_1 <= value_2
orvalue_1 > value_2
orvalue_1 >= value_2
Compares the value value_1
with the value value_2
.
Power (^)
Syntax:base ^ power
Raises base
to the power of power
.
AND
Syntax:value_1 AND value_2
Performs a Boolean join of two expressions with the AND
condition.
BETWEEN
Syntax:value [ NOT ] BETWEEN low AND high
Returns TRUE
if value
is in the range from low
to high
inclusive.
The option value NOT BETWEEN low AND high
returns the opposite value.
IN
Syntax:item [ NOT ] IN (<list>)
Checks whether the value matches at least one of the values listed in IN(...)
.
The option item NOT IN (<
list>)
returns the opposite value.
IS FALSE
Syntax:value IS [ NOT ] FALSE
Checks whether the value
value is false (FALSE
).
The value IS NOT FALSE
option returns the opposite value.
IS TRUE
Syntax:value IS [ NOT ] TRUE
Checks whether the value of value
is true (TRUE
).
The value IS NOT TRUE
option returns the opposite value.
LIKE
Syntax:string_1 [ NOT ] LIKE string_2
Matches the string string_1
to the template string_2
and returns TRUE
on match.
You can specify the value in string_2
or use the %
character to match a string of any length.
The string_1 NOT LIKE
option returns the opposite value.
When comparing values, the function is case-sensitive. You can use LIKE
along with UPPER or LOWER for case-insensitive comparison.
Negation (-)
Syntax:-value
Returns the number value
with the opposite sign.
NOT
Syntax:NOT value
Inverts a Boolean value.
OR
Syntax:value_1 OR value_2
Performs a Boolean join of two expressions with the OR
condition.