Joe,
Every random number generator I've ever worked with will not output 1.0, they can output 0.0. But the wording in help using "between" doesn't absolutely tell you whether or not the endpoints are included.
>So is the return value of RAND()...
0 < x < 1
or
0 < = x < = 1
...? According to help it is
0 < x < 1
.