In my experience, RAND() works fine too. But by nature, a random number is not necessarily a unique number. This makes the whole idea of using a random number for a unique key unwise. It is fine if combined with a value that can make it truly unique, like COM GUIDs, which use hardware numbers....


>VFP's RAND() function works just fine. I tested it some time ago and it's good.
>
>Vlad
>
>>Never trust any random number generator (Unless you can use a GUID)
>>
>>
>>Wayne