>Good Morning,
>
>How do you get the record number of a cursor record in SQL Server.
>
>It should be so easy but I can't find it in the help files.
>
>Thanks in advance for your kind assistance,
>
>Michael Brennan-White
There is no concept of record number in SQL Server. It is a set oriented DB not record oriented as VFP (DBF). You cannot do a query "SELECT * FROM MyTable WHERE Recno() = lnRecno".
OTOH, once you get a result set into a VFP cursor or table then you can use record numbers there, but why would you? Record numbers should not matter as they are moving targets (with deletions and all).