SQL to retrieve recordset in random order

<i><b>Originally posted by : David Park (park@lovetree.com)</b></i><br /><br />I need some help with retrieving recordset in random order. I know there has to some simple solutions, but my head has stopped spinning. Any help would be greatly appreciated.<br /><br />David

<i><b>Originally posted by : Doug Seven (doug.seven@codejunkies.net)</b></i><br /><br />Are you trying to have the results return in a random order, or getting the results in a random order, and want to organize it?<br /><br />Doug Seven<br />CodeJunkies.Net / ASPNextGen<br />doug.seven@codejunkies.net<br /><br />------------<br />David Park at 7/17/2000 5:24:00 PM<br /><br /><br />I need some help with retrieving recordset in random order. I know there has to some simple solutions, but my head has stopped spinning. Any help would be greatly appreciated.<br /><br />David

<i><b>Originally posted by : David park (park@lovetree.com)</b></i><br />I am trying to find an elegant way to retrieve data in random order.<br /><br />David park<br /><br /><br />------------<br />Doug Seven at 7/25/2000 1:07:52 PM<br /><br /><br />Are you trying to have the results return in a random order, or getting the results in a random order, and want to organize it?<br /><br />Doug Seven<br />CodeJunkies.Net / ASPNextGen<br />doug.seven@codejunkies.net<br /><br />------------<br />David Park at 7/17/2000 5:24:00 PM<br /><br /><br />I need some help with retrieving recordset in random order. I know there has to some simple solutions, but my head has stopped spinning. Any help would be greatly appreciated.<br /><br />David