>AFAIK, there's not a recno() style row-level variable in SQL Server. You may need to rethink approaches to this. Try a TOP X Clause with a specific order (maybe a "tModify" - style date of update, or an identity column).

There really isn't one. Shame. Anyway, the MSSQL table is recreated every night with a DTS job (it's a reference table, no inserts/updates on it hroughout the day). I added an alter table statement to the end of the DTS job to add an identity (sequential integer) column on the end. Now I can get the date for VFP in gulps, specifying the identity value as a parameter.

Thanks!