Raymond writes "How would you suggest returning records from a query in a random order?"
This question is answered in a two-part series on SQLTeam.com:
There is also a great article on displaying rows in random order using
Randomly Reordering an Array!
If you are interested in retrieving just a random segment of records from a recordset, be sure to check out these articles:
- Choosing a Random Record from a Recordset
- Getting a Random Record Using a Stored Procedure
- Returning a Random Number of Database Records