May 1999
Intermediate to advanced
1440 pages
38h 6m
English
The Compare field compares two values, then returns 1 if the comparison is true and 0 if it is false.
{ COMPARE FirstExpression Operator SecondExpression }
Either expression can be a number, a bookmark, a string, a nested field, or a value. You can also use the ? and * wild cards in an expression.
The following operators work with the Compare field:
| Operator | Meaning |
|---|---|
| = | Equals |
| > | Greater than |
| < | Less than |
| >= | Greater than or equal to |
| <= | Less than or equal to |
| <> | Not equal to |
To test whether the bookmark revenue exceeds the bookmark costs, and to return the value 1 if it does:
{ COMPARE revenue > costs }
Read now
Unlock full access