ABS

Returns the absolute value of a numeric value.

Syntax

ABS( numeric_value )

Argument	Required/ Optional	Description
numeric_value	Required	Numeric datatype. Returns the absolute value of a number. You can enter any valid expression.

Return Value

Positive numeric value. ABS returns the same datatype as the numeric value passed as an argument. If you pass a Double, it returns a Double. Likewise, if you pass an Integer, it returns an Integer.

NULL if you pass a null value to the function.

Example

The following expression returns the difference between two numbers as a positive value, regardless of which number is larger:

ABS( PRICE - COST )

PRICE	COST	RETURN VALUE
250	150	100
52	48	4
169.95	69.95	100
59.95	NULL	NULL
70	30	40
430	330	100
100	200	100