The RANGE function returns a value that is equal to the value of the maximum argument minus the value of the minimum argument. The type of this function depends on the argument types as follows:
| Argument Type | Function Type |
|---|---|
| All arguments integer | Integer |
| Numeric (some arguments may be integer) | Numeric |
FUNCTION RANGE ({argument-1} ... )
| argument-1 | Must be class numeric. |
The returned value is equal to the greatest value of argument-1 minus the least value of argument-1. The comparisons used to determine the greatest and least values are made according to the rules for simple conditions.