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