| Syntax: | NCDTY value_1 NCDTY value_2 |
|
| Return Value: | Y result |
|
| Precedence: | 6 | |
| Description: | This relational operator compares two fields and gives TRUE if the first is greater than the second |
|
| Example: | 100 > 100 = FALSE |
|
For a record with EMPLOYEE.NAME 'Jones' and ORDER_VALUE 7.00 with the following conditions:
NOT ORDER_VALUE > 5.00
The record would not be extracted because 7.00 is greater than 5.00 but NOT sets the result to FALSE.
ORDER_VALUE > 5.00 AND EMPLOYEE.NAME = 'Black'
The record would not be extracted because although 7.00 is greater than 5.00, the EMPLOYEE.NAME is not 'Black', and Yes AND No results in FALSE.
ORDER_VALUE 5.00 OR EMPLOYEE.NAME = 'Black'
The record would be extracted because only one of the conditions need be TRUE