SQLServerCentral / SQL Server 7,2000 / T-SQL / converting negative amounts into positive amount / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 04:28:43 GMT20RE: converting negative amounts into positive amounthttp://www.sqlservercentral.com/Forums/Topic443305-8-1.aspxTHANK YOU!!!!!!:)Tue, 15 Jan 2008 16:01:47 GMTMaiqueRE: converting negative amounts into positive amounthttp://www.sqlservercentral.com/Forums/Topic443305-8-1.aspxWell - assuming you REALLY want to do this (I mean - they were entered in as negative values for a reason, weren't they?), look into the Books online for the [b]ABS[/b] function. should do what you ask.Tue, 15 Jan 2008 15:59:31 GMTMatt Miller (#4)RE: converting negative amounts into positive amounthttp://www.sqlservercentral.com/Forums/Topic443305-8-1.aspxMultiply by -1.Tue, 15 Jan 2008 15:58:07 GMTJohn Rowanconverting negative amounts into positive amounthttp://www.sqlservercentral.com/Forums/Topic443305-8-1.aspxExperts,I have come accross a column that contains all paid orders but the amounts have a negative sign in front, how can I convert that netgative amount into a positve?please helpTue, 15 Jan 2008 15:51:59 GMTMaique