>>
>>
>>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.
Depending on your application if this is a problem you can put a second sort order in the query based on the table's primary id field. You elimnate the problem of more than extra recs and still keep the randomizing effect.