>>>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. :-)
William A. Caton III
Software Engineer
MAXIMUS
Atlanta, Ga.