Professional Web Applications Themes

Reversing Numbers - Microsoft SQL / MS SQL Server

Is there a function that will turn a -50 into 50 and 50 into -50? I am familier with ABS, but ABS turns everthing to positive, I just want to revers the signs. Thanks...

  1. #1

    Default Reversing Numbers

    Is there a function that will turn a -50 into 50 and 50
    into -50? I am familier with ABS, but ABS turns everthing
    to positive, I just want to revers the signs.

    Thanks
    borr Guest

  2. #2

    Default Re: Reversing Numbers

    multiply the number by -1
    Ex:
    declare x int
    select x = -1
    select x = (x * -1)
    print x

    --
    -Vishal

    "borr" <bdorr39hotmail.com> wrote in message
    news:041901c34722$1a1d16c0$a301280aphx.gbl...
    > Is there a function that will turn a -50 into 50 and 50
    > into -50? I am familier with ABS, but ABS turns everthing
    > to positive, I just want to revers the signs.
    >
    > Thanks

    Vishal Parkar Guest

  3. #3

    Default Re: Reversing Numbers

    How about:

    MyValue * -1


    "borr" <bdorr39hotmail.com> wrote in message
    news:041901c34722$1a1d16c0$a301280aphx.gbl...
    > Is there a function that will turn a -50 into 50 and 50
    > into -50? I am familier with ABS, but ABS turns everthing
    > to positive, I just want to revers the signs.
    >
    > Thanks

    Jerad Rose Guest

  4. #4

    Default Re: Reversing Numbers

    How about just multiplying it by -1?

    -50 * -1 = 50
    50 * -1 = -50

    Bob Castleman
    SuccessWare Software

    "borr" <bdorr39hotmail.com> wrote in message
    news:041901c34722$1a1d16c0$a301280aphx.gbl...
    > Is there a function that will turn a -50 into 50 and 50
    > into -50? I am familier with ABS, but ABS turns everthing
    > to positive, I just want to revers the signs.
    >
    > Thanks

    Bob Castleman Guest

  5. #5

    Default Re: Reversing Numbers

    How about just multiply by minus 1?

    Mike John

    "borr" <bdorr39hotmail.com> wrote in message news:041901c34722$1a1d16c0$a301280aphx.gbl...
    > Is there a function that will turn a -50 into 50 and 50
    > into -50? I am familier with ABS, but ABS turns everthing
    > to positive, I just want to revers the signs.
    >
    > Thanks
    Mike John Guest

  6. #6

    Default Re: Reversing Numbers

    SELECT CASE YourCol WHEN < 0 THEN ABS(YourCol) ELSE YourCOl * -1 END


    --

    Andrew J. Kelly
    SQL Server MVP


    "borr" <bdorr39hotmail.com> wrote in message
    news:041901c34722$1a1d16c0$a301280aphx.gbl...
    > Is there a function that will turn a -50 into 50 and 50
    > into -50? I am familier with ABS, but ABS turns everthing
    > to positive, I just want to revers the signs.
    >
    > Thanks

    Andrew J. Kelly Guest

  7. #7

    Default Reversing Numbers

    How about the formula: (0 - 50)

    >-----Original Message-----
    >Is there a function that will turn a -50 into 50 and 50
    >into -50? I am familier with ABS, but ABS turns
    everthing
    >to positive, I just want to revers the signs.
    >
    >Thanks
    >.
    >
    Guest

  8. #8

    Default Reversing Numbers

    I meant,

    select 0 - (-50) = 50
    select 0 - (50) = -50
    >-----Original Message-----
    >Is there a function that will turn a -50 into 50 and 50
    >into -50? I am familier with ABS, but ABS turns
    everthing
    >to positive, I just want to revers the signs.
    >
    >Thanks
    >.
    >
    Sagar Guest

Similar Threads

  1. Reversing the normal of a mesh
    By Mal in forum Macromedia Director 3D
    Replies: 0
    Last Post: November 15th, 04:01 PM
  2. Rollover, Rollout reversing
    By Todz in forum Macromedia Flash Sitedesign
    Replies: 4
    Last Post: March 3rd, 03:49 PM
  3. Reversing Motion Tweens
    By GKM in forum Macromedia Flash
    Replies: 1
    Last Post: July 30th, 01:00 PM
  4. Reversing a 50/1.8 on my Coolpix 5000.
    By Eyron in forum Photography
    Replies: 2
    Last Post: June 29th, 06:09 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139