Benn,

Another problem with RAND() is that each time it is called with the same seed value it generates the same sequence of values. The ony safe way to get unique PK values is to use an ID table that you know will not repeat a value.