Change sign of a numeric variable in select statement? 1

[CraigBest]

Hi,

I am trying to select a value from a table that I must use as a negative, but it is stored as a positive value. I would like to change the sign of the value in the select statement if that's possible so it can be used in a calculation as part of a stored procedure. I can't seem to find a function that will do this (sign simply returns 1 or -1 depending on the value of the field interrogated).

Anyone know of a way to do this?

Thanks

CraigHartz

 

[hoinz]

why not this:
select -field from table;

or maybe:
select -field as field from table;

 

[taupirho]

select your_field * -1
from your_table


In order to understand recursion, you must first understand recursion.

 

[CraigBest]

Yep, that did it - thanks. I figured it was something simple like that, especially when I couldn't find an example in the book

CraigHartz