>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