How to make Random in T-SQL with negative and positive numbers?

Question

Database

I came across this problem:
Rand() * 100 for example, randomly displays numbers up to 100, and Rand() * ( - 100 ), from 0 to -100.
And how do you make them interspersed?
Of course, you can subtract one from the other, that is, if it turns out that the random number, which, as a minuend, is less than the random number, which is subtracted, then the number is negative, otherwise, then positive. But maybe there is some other function...

Answer 1

Well the crutch level
(Rand() * 200) - 100