Awww....SOB! You're right.....!
>>=RAND(-1) && Initialize to system clock
>>SELECT table
>>COUNT TO nMaxValue FOR !DELETED()
>>nWinnerRecord=INT(1+RAND()*nMaxValue)
>>GO nWinnerRecord && This is the winning record
>
>:)) You forgot the deleted records just before your last line of code. :)
>
>Vlad
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
