Showing posts with label negative. Show all posts
Showing posts with label negative. Show all posts

Friday, March 30, 2012

Invert values

How do I go about inverting values. That is:
-change all positive to negative and change all negative to positive
I have tried using abd function but that only changes negative to positive??
SET amt = Abs(amt)
What the best way of performing this in sql?Set Amt = Amt * -1