>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.
Select Top 411 rand() as rendexp, * From Yourtable Into ... Order by 1
Edward Pikman
Independent Consultant