David Burrows (10/16/2007)
* -1 should workwhat is the datatype and what makes you think it did not work
btw
preceding a column or variable with - will achieve the same, eg
DECLARE @myvariable int
SET @myvariable = 1
SELECT @myvariable,-@myvariable
I think David means ...
DECLARE @myvariable int
SET @myvariable = 1
SELECT @myvariable,@myvariable * -1
But BOTH work. It must be a another issue, but I don't think it's a dat-type issue. :hehe:
EDIT: Sorry Guys, I replied WAY to quick, and mis-read David's post
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg