Re: Database Paging using MSSQL 2000

>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. Look up "cursor" in your MS SQL documentation. It's not as mind-numbingly simple as LIMIT, but it works. -- Visit the Zend Store at http://www.zend.com/store/ Wanna help me out? Like Music? Buy a CD: http://l-i-e.com/artists.htm Volunteer a little time: http://chatmusic.com/volunteer.htm