SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX Functions and Expressions

HP NonStop SQL/MX Reference Manual—523725-004

9-10

ABS Function

The ABS function returns the absolute value of a numeric value expression.

ABS is an SQL/MX extension.

numeric-expression

is an SQL numeric value expression that specifies the value for the argument of

the ABS function. The result is returned as an unsigned numeric value if the

precision of the argument is less than 10 or as a LARGEINT if the precision of the

argument is greater than or equal to 10. See Numeric Value Expressions on

page 6-50.

Examples of ABS

•

This function returns the value 8:

ABS (-20 + 12)

ABS (numeric-expression)