chaning a positive to negative

[Neozero]

What is the best way to update a field to change it to a negative number from a positive? Would I use insert or update?


EXAMPLE: I want to change 85996 to show as -85996.

 

[JamesLean]

UPDATE mytable
SET myfield = 0 - myfield
WHERE myfield > 0

--James

 

[ThatRickGuy]

or

UPDATE mytable
SET myfield = -1 * myfield

if you just want the opposite wether it's positive or negative

-Rick

 

[dnoeth]

Why don't you use a simple

SET myfield = -myfield

there's no need for "-1 * myfield" or "0 - myfield" ;-)

Dieter

 

[ThatRickGuy]

SET myfield = -myfield

which opperation does this perform though? -1*x or 0-x?

-Rick