Quick Reference Table
Report Builder supports the same operators as the Progress 4GL, plus the “-” string concatenation operator.
Table C–2 lists the five main types of operators and the operators within each type.
Table C–2: Operators
Type
|
Operator
|
Description
|
Arithmetic
|
+
|
Addition
|
-
|
Subtraction
|
/
|
Division
|
*
|
Multiplication
|
MODULO
|
Remainder after division
|
Date
|
+
|
Addition of days to a date. For example:
Order-Date + 30
|
-
|
Subtraction of days from a date or subtraction of one date from another. For example:
Ship-Date - Order-Date
|
Character
|
+
|
Concatenation (joining two character strings into one). For example:
First-name + Last-name
|
-
|
Concatenation after removing trailing spaces from the string before the operator. For example:
First-name - " " + Last-name - ""
|
Relational
|
BEGINS
|
Returns a logical value indicating whether the first operand begins with the second operand
|
MATCHES
|
Returns a logical value indicating whether the first operand matches the pattern specified as the second operand
|
= or EQ
|
Equal to
|
<> or NE
|
Not equal to
|
< or LT
|
Less than
|
<= or LE
|
Less than or equal to
|
> or GT
|
Greater than
|
>= or GE
|
Greater than or equal to
|
Logical
|
NOT
|
Logical not
|
AND
|
Logical and
|
OR
|
Logical or
|
NOTE: The Insert Filter Condition dialog box lists the IN-RANGE and IN-LIST functions as operator choices. See
"Report Builder Functions," for descriptions of these functions.