hi to all,

In a SELECT SQL written in Oracle you can insert in the where expression a clause to stop the query after to have found N records, and you can do this with :

SELECT .... WHERE .... AND rownum <= 500

Can I do this with FoxPro ?
I don't want to use a TOP N because this before return all row and after count the rows.
I'm looking for something that force the user to do a query with a normal return or a partial return (if the query return 10000 customer I think that the user will refine the query)

TIA
Renato