>>>In VFP I would assume we would need
>>>
>>>rand(-1)
>>>
>>>select top * from ( select *, rand() as Rec from myTable) Derived order by Rec
>>>
>>>but this looks like very inefficient method and I would use the technique Sergey described instead, however, I'm not exactly sure how would it work in case of deleted records.
>>
>>Deleted records in quote of the day table? :-)
>>There are none.
>
>But what if we have deleted records there for some reason?
Then you PACK the table before you redistribute it to the customers :-)
That is an internal table so you could do whatever you want with it :-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.