>>>SQL Server allow to order on any expression even the one that does not exists in the column list. A GUID is generated for each record at the time when sorting is performed.
>>
>>And so does VFP. I used index on rand() who knows how many versions ago... 6.4 IIRC. The key() is just an expression.
>
>No VFP doesn't support it in a query.

Right - in a query it would take

select rand(), * ... order by 1

i.e. a column needs to be added.