>>I have a dbf table of members and related info.
>>How can I get a random sampling of 411 out of the existing 6812?
>>I been trying to apply rand() but with no success..
>>Thank you for your understanding.
>
>Hi Joe,
>
>There was a thread on this topic a while back. I believe you can get what you want by playing with something like:
>
>
>SELECT RAND() AS Dummy, MyField1, myField2, ... ;
> FROM MyTable ;
> ORDER BY 1 ;
> INTO CURSOR MyCursor
>
>
>Bill
I got 3 responses yours seemed the easist and most relevent to exactly what I was doing and it worked out fine. Thanks alot guys!!!