>Hi to all,
>
>I wanted to display a list of TOP 10 records base on a given criteria using SQL command, but I'm not sure with the syntax.
>
>Thanks.

SELECT TOP 10 * FROM myTable

Take a look at topic "SELECT - SQL" in VFP's help file for the complete syntax of this command.