The SQL Server is more strict about order of clauses in a SELECT than VFP.

>The following SQL Select works in VFP but gives me error in SQL Server something to do with syntax near TOP
>
>

SELECT  top 100 * FROM mytable ORDER BY order_no
>

>
>What do I need to change in SQL Server?