Random selection of records

[Eugene Anthony]

How can I randomly select a single record from my ms sql database using
asp.net 2.0?

Your help is kindly appreciated.

Regards

Eugene Anthony

 

[Aidy]

select top 1 * from YourTable order by newid()