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

The "TOP x" clause in a SELECT SQL has a bug in VFP and it may return more than x records.

But I like the idea. I will keep it in mind. Thanks.

Vlad