I am using the same SQL commands as in VFP to select randomly 5 records. I make use of RAND() as the first field of the SQL. However, in order for that to work, RAND(-1) has to be executed. Going through OleDb, would it there be a way to achieve all that from within the same SQL?