converting negative amounts into positive amount

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » T-SQL » converting negative amounts into positive...

converting negative amounts into positive amount

Rate Topic

Display Mode

Topic Options

Author

Message

Maique

Posted Tuesday, January 15, 2008 3:51 PM

Valued Member

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 9:46 AM
Points: 64, Visits: 233

Experts,
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 help

Post #443305

John Rowan

Posted Tuesday, January 15, 2008 3:58 PM

Hall of Fame

Group: General Forum Members
Last Login: Tuesday, January 29, 2013 10:54 AM
Points: 3,837, Visits: 3,821

Multiply by -1.

John Rowan

======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden

Post #443311

Matt Miller (#4)

Posted Tuesday, January 15, 2008 3:59 PM

SSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 7:57 PM
Points: 6,998, Visits: 13,949

Well - 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 ABS function. should do what you ask.

----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

Post #443314

Maique

Posted Tuesday, January 15, 2008 4:01 PM

Valued Member

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 9:46 AM
Points: 64, Visits: 233

THANK YOU!!!!!!:)

Post #443315

« Prev Topic | Next Topic »

Permissions