ABS (Absolute Value) The ABS function returns the absolute value of number. The result has no sign and is formatted according to the current NUMERIC settings. ABS( number ) Examples ABS('12.3') -> 12.3 ABS(' -0.307') -> 0.307