2.2.3.2.19.1 Operator Behavior
The behavior of operators in an expression depends on the types of the operands. The following table lists the allowed operators and the results they produce with operands of various types.
Operator 
Operand1 
Operand2 
Result description 

+ 
LONG 

Unary plus. 
+ 
LONG 
LONG 
Binary addition. 
+ 
STRING 
STRING 
Concatenation of strings. 
 
LONG 

Unary minus. 
 
LONG 
LONG 
Binary subtraction. 
* 
LONG 
LONG 
Binary multiplication. 
/ 
LONG 
LONG 
Integer division (for example, 7/3 = 2). 
% 
LONG 
LONG 
Modulo operator (for example, 7 % 3 = 1). 
++ 
LONG 

Unary postincrement or preincrement operator. Variable supports set operations. 
 
LONG 

Unary postdecrement or predecrement operator. Variable supports set operations. 
= 
LONG 
LONG 
Simple assignment. 
= 
STRING 
STRING 
Simple assignment. 
= 
DATETIME 
DATETIME 
Simple assignment. 
< <= > >= == != 
LONG 
LONG 
Relational operator. Result is a LONG with a value of 0 or 1. 
< <= > >= == != 
STRING 
STRING 
Relational operator. Result is a LONG with a value of 0 or 1. 
< <= > >= == != 
DATETIME 
DATETIME 
Relational operator. Result is a LONG with a value of 0 or 1. 
! 
LONG 

Unary Not. Result is a LONG with a value of 0 or 1. 
&& 
LONG 
LONG 
Logical AND. Result is a LONG with a value of 0 or 1. Shortcut evaluation is supported. For example, in the expression "a && b", if "a" is false, "b" is not evaluated. 
 
LONG 
LONG 
Logical OR. Result is a LONG with a value of 0 or 1. Shortcut evaluation is supported. For example, in the expression "a  b", if "a" is true, "b" is not evaluated. 
() 


Allows precedence to be overridden. 
?: 
Any 
Any 
Conditional expression; for example, "(a < b)?c:d". If condition "a < b" is true, the value is "c", and "d" is not evaluated. If the condition "a < b" is false, the value is "d", and "c" is not evaluated. 
, 
Any 
Any 
Used to separate parameters in a function call or used in an expression to allow multiple statements to be evaluated. For example, "d = ( a = b, c = e )" will assign the value of "e" to "d". 