Tenzin Tenzin -4 years ago 173
SQL Question

Opposite of the ABS function

I know that with

you can convert negative numbers to positive numbers.

But with what function do you convert a positive number to a negative number?

Is there even any?

Answer Source


select -abs(123),-abs(-123)

-abs(123) -abs(-123) 
--------- ---------- 
-123      -123     
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download