have an identity field on the db. <BR><BR>then do a select count(*) on the table. <BR><BR>get a random number from 1 - the count.<BR><BR>Then do a select * table where id = (random number)<BR><BR>i did this on a site i have and it works really well. Just make sure there aren't any holes in your identity field (missing numbers) or you'll get back missing records.
> why dont u just pull back all the records in the database ...<BR><BR>Primarily because that's really, really slow.<BR><BR>However, in a few cases that is the best choice.<BR><BR>See http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=65