Multipling by Negative Numbers

[jakenoble]

Hi

how do i mulitiple by a negative numbers, if i have

Select This.That*-50 the it multiples it by 50 not minus 50.

The value in This.That will either be a 1 or a zero. So if its a zero multipling it by -50 will give me zero, multiplingit by one with giveme -50, which is what i want.

How do i solve this?

[phoztech]

select (crap*(-50)) crap
from xyz
where ....