REJECTED(condition,...,condition)
| condition | A conditional expression to evaluate. |
| Return: | REJECTED returns a single value. |
The REJECTED function evaluates which of the list of conditions returned false and returns its ordinal position in the list of conditions. Zero (0) returns if none return false. This is the opposite of the WHICH function.
Example:
Rejects := REJECTED(Person.first_name <> 'Fred',Person.first_name <> 'Sue');
// Rejects receives 0 for everyone except those named Fred or Sue