>>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 ...