Returning Rows in Random Order 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: Returning Rows in a Random Order Returning Rows in a Random Order - Part II There is also a great article on displaying rows in random order using GetRows: 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 Happy Programming!

Article Information
Article Title:	Returning Rows in Random Order
Article Author:	Scott Mitchell
Article URL:	http://www.4GuysFromRolla.com/webtech/sqlguru/rriro.shtml