SQL converting a negative number to positive


In our SQL Server database we have money values that are negative.  But I need to convert all negative values to positive values.  I am using the following code in Query Analyzer:

--Convert all negative numbers to positive numbers
IF (SELECT field FROM table) < 0
      UPDATE Table
      SET field= (field * -1)

But I get the following error:
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

What am I doing wrong?  Or is there a better way to get the absolute value of a negative number?

Thanks in advance.
Who is Participating?
Scott PletcherConnect With a Mentor Senior DBACommented:
There is a built-in function, ABS(), for doing that:

UPDATE table
SET column = ABS(column)
WHERE column < 0
Anthony PerkinsCommented:
Lose the IF and use a where clause:

SET field= (field * -1)
Where SIGN(field) = -1
update table
set field = field * -1
where field < 0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.