>>>What would be the best technique to select 10 records randomly from a table?
>>
>>This is how I do it.
>>
>>
>>SELECT TOP 10 Table.field1, RAND() AS Dummy;
>> FROM Table;
>> ORDER BY 2;
>> INTO CURSOR tmpStore
>>
>
>To make sure of not having the same record, I added the NUMERO unique ID field in the RAND().
>
>SELECT TOP 10 NUMERO,RAND()+NUMERO AS Dummy ...
IMHO, this is useless. I don't see how you can get twice the same record using a select SQL.
Vlad