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)
