If you're using SQL Server, you can do something like:
SELECT TOP 1 Col1, Col2 FROM SomeTable ORDER BY NewId()
The trick here is the NewId function that returns a (semi) random value every time.
Cheers,
Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
|