Stochastic Queries

As a part of some experimental work I've been doing, I need to write what I think is best described as a stochastic quota query.

I would like to write a query like

SELECT RANDOM 5 COLUMN_FOO FROM TABLE_BAR where RANDOM is like TOP, except that for successive queries, I get a (possibly) different set of 5 COLUMN_FOO values from table TABLE_BAR.

Has anyone seen such a beast?

Thanks in advance,
Joe Received on Mon Sep 10 2007 - 01:21:54 CDT