I need to switch my numbers neg/pos

  • Thread starter Thread starter Bryan Harris
  • Start date Start date
B

Bryan Harris

I am trying to get some info out of our ERP system and the way it gets input
to the database our material issues show up as a negative number.

I can pull that data out, but I then want to switch the numbers to a
positive number. Is there and easy way to do that in a query?

Thanks,
Bryan
 
SELECT (0 - MyValue) AS MyCorrectedValue FROM MyTable

or

SELECT Abs(MyValue) AS MyCorrectedValue FROM MyTable
 
Back
Top