Ok, thanks. This looks similar to the SQL Mag site solution. I'll implement one of these, at least for now.

Bill

>Hi Bill,
>
>Get next n records from previous call Thread #691967
>
>>
>>Yeah, probably incomplete info there. I was thinking of the case where a table will have (at least) a clustered index which provides the "natural order", I.e. with a clustered index a non-ORDER BY query would return rows in the clustered index order. My bad.
>>
>>Ok, I'll look at the code. I found a couple of ways to do it also. One I came up with and another I found on the SQL Server Magazine site. There really are no "efficient", simple ( I.e. without auxiliary tables, etc. ) ways to do it that I could find, since SQL Server has no concept of an Nth row like we think of in VFP.
>>
>>The reason is I've been researching "paging" through data in SQL Server. I.e. based on a particular order, retrieving a "page" (or group) of rows, then next "page", previous "page", or an arbitrary "page" of rows.
>>
>>I've found ways to do it on tables that aren't too large. For large tables the methods become expensive unless an auxiliary work table is created.
>>