>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
--sb--