See my other reply in this thread.

Vlad

>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....