>>Mike,
>>Are all the records the same? You specify a * in the field list which implies there is more than the 1 field (descrip). If all the values of all the rows are the same, you could add a DISTINCT to your SQL statement.
>>
>>FWIW, VFP seems to be unique in how it implemented TOP. SQL Server returns a single row.
>>
>

---

>Larry,
>
>SQL Server will return the same result as VFP if you add WITH TIES to SELECT

Thanks for the memory jog. I knew there was a way to do this.

But in this case, SQL Server does have that extra keyword functionality that Mike was looking for, where VFP does not.