Is there another way to shuffle a list of phone numbers so that they are random?
thx
>If it's unique, it's not random! And if it's random than it's not necessary unique! :)
>
>Vlad
>
>>Yeah, I was just hoping for something like RAND(,U) <-- a unique parameter.
>>
>>I'm told that C++'s RAND() function returns unique numbers...
>>
>>Oh well, I did the SEEK to verify uniqueness and it works fine.
>>
>>Thanks
>>
>>>This is normal. Random numbers are not unique.
>>>
>>>Each time you generate a new number you must do a SEEK and add it only if it is not already in your table.
>>>
>>>Vlad
>>>
>>>>I fill a file having 12000 records with 'random' numbers. Index on number unique
>>>>shows only 7550 unique numbers
>>>>
>>>>>What's the problem? Ie: What doesn't work?
>>>>>
>>>>>Vlad
>>>>>
>>>>>>We are using RAND() to create a random sampling of a phone number file so
>>>>>>we need unique numbers so we don't re-use phone numbers
>>>>>>
>>>>>>Any way?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only