http://snippets.dzone.com/posts Sun, 27 Jul 2008 06:59:35 GMT DZone Snippets: ms code http://snippets.dzone.com/posts/show/3584 // select a random row in SQL Server, apparently. Untested. <br /> <br /><code> <br />SELECT TOP 1 column FROM table <br />ORDER BY NEWID() <br /></code> Mon, 26 Feb 2007 11:33:18 GMT http://snippets.dzone.com/posts/show/3584 brook (Robert Brook)