Post reply

Convert positive number to a negative

  • July 26, 2011 at 4:49 am

    #1358350

    SQL noob here, but would ABS work?

  • July 26, 2011 at 4:55 am

    #1358353

    preynolds 73137 (7/26/2011)

    SQL noob here, but would ABS work?

    ABS would work for the opposite, (negative to positive)

  • July 26, 2011 at 7:53 am

    #1358523

    Deleted because code already posted.

    N 56°04'39.16"
    E 12°55'05.25"

  • July 26, 2011 at 8:26 am

    #1358555

    steveb. (7/26/2011)

    preynolds 73137 (7/26/2011)

    SQL noob here, but would ABS work?

    ABS would work for the opposite, (negative to positive)

    Except if you combine both

    -ABS(value)

    would always give you a negative result even if value was negative

    Far away is close at hand in the images of elsewhere.
    Anon.

  • October 25, 2011 at 11:45 am

    #1399241

    Try:

    SET @var = -1 * ABS(@var)

Viewing 5 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply