Database Paging using MSSQL 2000

Hello All! I am implementing a database application using PHP4 and MSSQL2000. I have a database table which has a large no. of tuples. I want to display the data in the form of pages with Prev Next buttons. I wanted to know if there is some syntax in the MSSQL Select statement which can allow me to limit the no. of records being returned. I am lookin at functionality which is similar to LIMIT in Mysql. for ex, LIMIT 10,10 in MYSQL returns to me a maximum of 10 records starting from the 10th record in the returned recordset. is there any similar functionality available in MSSQL. if not, how should I go about implementing this functionality. I would also appreciate if someopone could point me to a good tutorial on the subject using MSSQL server as the database server. best regards Ankur Verma HCL Technologies A1CD, Sec -16 Noida, UP India