Negative and Positve data from Sql

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • AceNspades
    New Member
    • Apr 2007
    • 2

    Negative and Positve data from Sql

    Hi.

    I have a Column A that returns both positive and negative numbers. Is there a way to convert just the negative numbers to positive?
  • iburyak
    Recognized Expert Top Contributor
    • Nov 2006
    • 1016

    #2
    Try this:


    Code:
    Select abs(-20)
    Good Luck.

    Comment

    • AceNspades
      New Member
      • Apr 2007
      • 2

      #3
      Thank you for pointing me in the right direction!

      Comment

      Working...