Hi,

How could I write a query that randomly selects 100 records from a table? Each record has a unique record ID. Thanks very much for taking the time to read this.

This article should answer your question:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q208855