>>Hi everybody,
>>
>>How can I randomly select n (110) codes from some huge table, so these codes would be unique? I'm trying to create a test case now...
>
>I was forgetting that I had, at some moment, used something like:
>
>

>copy to sample for recno() % 1000 = 0
>

>
>In other words, copy all records whose recno() is a multiple of a certain number.
>
>Quick to code, not so quick in executing.
>
>Hilmar.

That's essentially the same idea, as Mike's. I would first select all unique codes in table, then using some random number, select records for recno()%RandomNumber = 0.