Subject Re: how random is rand() ?
Author duilio_fos
"Ann W. Harrison" <aharrison@i...> wrote:

> I can't speak for your goodness

wise girl :)

>that function is an embarrassment

I (sort of) solved the problem by writing :

select mod(floor(rand()*1000000,100) from rdb$database into result

This gets much better random results btw 0 and 99 (what I needed).

Thank you