Results 1 to 2 of 2

Thread: Invert values

  1. #1
    Join Date
    Jul 2004

    Unanswered: 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?

  2. #2
    Join Date
    Jul 2004

    Reverse sign

    Set Amt = Amt * -1

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts