I have my database server and web server sitting miles away from one another. I have a table which has almost 100,000 records. i would like to show only 100 records at a time on my asp page. So i do not want to retrieve all the records and use the pagecount of recordset object.<BR><BR>I have used the TOP keyword also. But the problem with TOP Keyword is that it only gets n rows starting from the top and cannot start somewhere in the middle. If there is then, i could use the <prev> ... <next> content linkers to retrieve the necessary data.<BR><BR>Isn't there any way in which we can retrieve some rows from the middle like 50th row to 100th row?