Randomize data from SQL statement

Hi,

I want to generate a 30% random sample output data from my Order_number field of my Order_item table. Is there any technique or function that I could use?. I would like it to be done in SQL Statement not in PL/SQL.

Thanks
Tricia Kha
tkha_at_accesscom.com Received on Mon Sep 21 1998 - 00:00:00 CDT