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

Printable View

- July 10th, 08:30 PMborrReversing 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

- July 10th, 08:38 PMVishal ParkarRe: 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...Quote:

> 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

- July 10th, 08:39 PMJerad RoseRe: Reversing Numbers
How about:

MyValue * -1

"borr" <bdorr39hotmail.com> wrote in message

news:041901c34722$1a1d16c0$a301280aphx.gbl...Quote:

> 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

- July 10th, 08:40 PMBob CastlemanRe: 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...Quote:

> 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

- July 10th, 08:40 PMMike JohnRe: Reversing Numbers
How about just multiply by minus 1?

Mike John

"borr" <bdorr39hotmail.com> wrote in message news:041901c34722$1a1d16c0$a301280aphx.gbl...Quote:

> 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

- July 10th, 08:40 PMAndrew J. KellyRe: 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...Quote:

> 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

- July 10th, 09:06 PMReversing Numbers
How about the formula: (0 - 50)

Quote:

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

Quote:

>to positive, I just want to revers the signs.

>

>Thanks

>.

>

- July 10th, 09:10 PMSagarReversing Numbers
I meant,

select 0 - (-50) = 50

select 0 - (50) = -50

Quote:

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

Quote:

>to positive, I just want to revers the signs.

>

>Thanks

>.

>

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