Making all values negative

  • Thread starter Thread starter Brendan Mather
  • Start date Start date
B

Brendan Mather

I have a column in a table and I'd like to make all 7100 values to be
negative, what's the fastest way to do this.

thanks,
Brendan
 
Brendan Mather said:
I have a column in a table and I'd like to make all 7100 values to be
negative, what's the fastest way to do this.
Click to expand...

Update query.

UPDATE YourTableName
SET YourField = Abs(YourField) * -1
 
Back
Top