Sorting records to make a random sort?

[mistery]

Hello

   I have the need to mix up a large amount of records. I want them to be sorted so they are completely random. No order at all. Is there an easy way to do this?

Thank you.

[comment]

Easy - yes, fast - no. You could define an unstored calculation field (result is Number) =

Random

and sort by it. If the amount of your records is really large, this could take a while. Perhaps if you explained the purpose behind this, a faster way could be found to reach the real destination.

[mistery]

I just want to break down the big file into smaller ones without any order. 

[comment]

I just want to break down the big file into smaller ones without any order. 

 

That's still a task, not a purpose - unless you are dividing up an estate among heirs...

 

Anyway, it looks like you'll only be doing this once so I guess you can just wait it out.