>Otherwise, I wouldn't use an index for this, I'd create a field just for the sort, have a routine populate that field randomly (using rand() most likely), and SET ORDER to an index on that field whenever you want a new random view of your cursor.

Good idea, thanks Mike!
John