specify minimum value for random 1

[crystalhelp]

I found the following in the forum archives.

select (rand() * MaxNum) + MinNum

However, it doesn't work. I specified 59 as my max and 48 as my min. It returned random numbers higher than 59. If I set my MinNum to 1, it returned numbers from 1-59. How can I specify a range from 48-59?

 

[karluk]

Try

select (rand() * MaxNum-MinNum) + MinNum

For the range 48-59 that works out to

select (rand() * 11) + 48

 

[karluk]

I missed a necessary set of parenthesis in the above formula. It should be

select (rand() * (MaxNum-MinNum)) + MinNum