If you are using SQLServer 2K (not sure if it works in 7) you could use SELECT TOP 10 * FROM Foo ORDER BY NewID()
HTH -----Original Message----- From: admin [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 07:11 To: CF-Talk Subject: ot - random sql select is there an easy way to select say 10 records at random from an sql table ? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com