http://developer.mimer.com

Scalar Interval Functions

---

The following section documents scalar interval functions.

ABS

Returns the absolute value of the given numeric expression.

Syntax

Syntax for the ABS function:

value is a numeric or an interval value expression.

Rules

• The function returns the absolute value of value.
• If the value of value is NULL, then the result of the function is NULL.

Example

 SET INT_VAL = ABS(-15);  -- sets INT_VAL to 15

Upright Database Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 dbtechnology@upright.se