Operator
|
Description
|
Usage
|
+
|
Adds two numeric expressions
|
expression + expression
expression
Any expression resulting in a numeric value
|
+
|
Joins two character string or expressions
|
expression + expression
expression
Any expression resulting in a character or string value
|
+
|
Adds a number days to a date
|
date + days
date
Any expression that results in a date
days
Any expression with an integer value
|
-
|
Subtracts a numeric expression from another
|
expression - expression
expression
Any expression resulting in a numeric value
|
-
|
Subtracts a number of days, or a date, from a date
|
date - days
date - date
date
Any expression that results in a date
days
Any expression with an integer value
|
*
|
Multiplies two numeric expressions
|
expression * expression
expression
Any expression resulting in a numeric value
|
/
|
Divides one numeric expression by another numeric expression
|
expression / expression
expression
Any expression resulting in a numeric value
|
AND
|
Returns TRUE if each logical expression is true
|
expression AND expression
expression
Any expression resulting in a logical value (TRUE or FALSE)
|
EQ
=
|
Returns a True value if two expressions are equal
|
expression EQ expression
expression = expression
expression
A field name or expression. The data types on each side must be the same
|
GE
>=
|
Returns a True value if the first expression is greater or equal to the second
|
expression GE expression
expression >= expression
expression
A field name or expression. The data types on each side must be the same
|
GT
>
|
Returns a True value if the first expression is greater than the second
|
expression GT expression
expression > expression
expression
A field name or expression. The data types on each side must be the same
|
LE
<=
|
Returns a True value if the first expression is less then or equal to the second
|
expression LE expression
expression <= expression
expression
A field name or expression. The data types on each side must be the same
|
LT
<
|
Returns a True value if the first expression is less than the second
|
expression LT expression
expression < expression
expression
A field name or expression. The data types on each side must be the same
|
NE
<>
|
Returns a TRUE value if two expression are not equal
|
expression NE expression
expression <> expression
expression
A field name or expression. The data types on each side must be the same
|
NOT
|
Returns TRUE if the expression is false and FALSE if the expression is true
|
NOT expression
expression
Any expression resulting in a logical value (TRUE or FALSE)
|
OR
|
Returns a TRUE value if either of two logical expression are TRUE
|
expression OR expression
expression
Any expression resulting in a logical value (TRUE or FALSE)
|