Select *, rand() as myrand from mytable top x into cursor mycursor order by myrand

>I'm trying to figure out how to get Visual FoxPro 6 to run a query that will pick randomly x number of records from a given table. I've tried doing this thru a hardcoded program however I haven't had much luck. Any help would be appreciated...
>
>-lukasz