Home Forums SQL Server 7,2000 T-SQL converting negative amounts into positive amount RE: converting negative amounts into positive amount

  • 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?