Re: Select random rows?

Connor McDonald <connor_mcdonald_at_yahoo.com> wrote in message news:3826AB3C.1C7F_at_yahoo.com...
>
> Sorry - I should have added
>
> my random function is a variant on the linear congruence algorithm so
> that no rows will be repeated...
>
> The 500 can be replaced with a number more than the ceiling for the
> table - I just chose that as an example

Theoretically, if your random function returns a integer between 0 and, say, 499, there is NO ways to assure the function values will not be repeated, or, it can NOT be a random function. Received on Tue Nov 09 1999 - 09:27:52 CST