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