How to select random records?

Hi,

Is there a way to select certain number records from a table randomly? I am doing a survay application that needs to select records from table randomly. What I am doing now is to select all records then fetch them back and skip records periodically.
Is there a better way to do it?

Thanks.
Bob Received on Fri Sep 26 1997 - 00:00:00 CDT