Renato,

Can you clarify why you don't want to use the TOP n clause? I'm not sure I understand your objection.

>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