SQL Update to flip sign of a value?

Question

Someone entered a ton of numeric data into a table with the sign backwards.

Is there a clean way to flip the sign in the numeric column with a SQL statement?

Answer 1

update my_table
  set amount = -amount
  where <whatever>