if you are using ado and asp then try using the pagesuze, pagecount, and 
absolutepage properties of your recordset.

> Hello, 
> 
> If "Select Top 100 * from table order by field" will return top 100 
> records, how to make query to get second page, i.e. records from 101 
till 
> 200?
> 
> Thanks
> Giedrius