>>Actually, your are right. What I meant to say was after opening a cursor I want to issue a "FETCH ABSOLUTE intPos" to go to a specific record then return the next 100 entries form that cursor, rather than return the whole cursor and have ASP process it.
>
>This sounds like "paging". I use a table variable (SQL Server 2000) with an IDENTITY column to create the row number. Then a simple BETWEEN get the section of rows that are of interest. I was surprised as the speed that SQL Server can handle this.
>
>-Mike

This sounds interesting. What is a table variable? I'm using SQL 7 so how would I get this done using this approach?

Thanks for the help...
Mike