Return the absolute value of a number

SELECT ABS(2);   -> 2
SELECT ABS(-46); -> 46

The sign of a number compares it to 0.

Sign | Result | Example —— | —— | —– | -1 | n < 0 | SELECT SIGN(42); -> 1 0 | n = 0 | SELECT SIGN(0); -> 0 1 | n > 0 | SELECT SIGN(-3); -> -1

SELECT SIGN(-423421); -> -1