Thanks, that's pretty much where I want to be. I was trying to SQL-ize what you gave me and am not getting there. I want to Rushmore-optimize the retrieval, and it seems like I can't do that without indexing on RecNo(). How could I do a Random SQL sampling?



>=RAND(-1) &&Randomize to sysclock
>COPY TO temp FOR RAND()<0.10