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

This is the perfect solution with an exception. rand() might return the same value for top 10 more than once thus resulting set would be more than ten recs. Sure not a problem just get the first ten recs than.