SELECT TOP is in the official help syntax of a foxpro sql statement. If you are using the correct ODBC driver you should be able to do it. If this doesn't work you might wanne try 'select * from ... where recno() > 100'. I know in sql server you have to do a "set rowcount = 100" first. But you're not really using sqlpasstrough nor sql server.