select * from your table into cursor tmp
for i=1 to 10
  lnRecno = int(rand()*_tally)
  go lnRecno
  save the record somewhere
endfor

It's not the best technique, it's my way ;) >What would be the best technique to select 10 records randomly from a table?