The docs say RAND() returns a value between 0 and 1 but I assume it actually returns a value either from 0 to almost 1 or a little greater than 0 to 1. Does anyone know for sure?

Thanks, Chaim