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

Glad it worked. Actually I was just passing on something I learned from others at UT. :-)