I believe the 'set rowcount' will finitely limit the query... ie, you'll only get back that many rows... you won't be able to 'continue'... if that's what you want, that will work... L -----Original Message----- From: Michael Peppler [mailto:[EMAIL PROTECTED]] Sent: Friday, February 02, 2001 2:37 PM To: Justin Kelley Cc: [EMAIL PROTECTED] Subject: Re: MySQL Limit Clause/MS-SQL 7 Equivalent Justin Kelley writes: > I know that in MySQL there is a LIMIT Clause (LIMIT 21,30). MS SQL however, > appears to have no equivalent that I have found. Does anyone know > differently or have an answer for this problem? The only other I've found > suggests using unique ID numbers and using a TOP 20 where number > 20. > Which won't work because of how this searches. Look at the SET ROWCOUNT option. Michael -- Michael Peppler - Data Migrations Inc. - [EMAIL PROTECTED] http://www.mbay.net/~mpeppler - [EMAIL PROTECTED] International Sybase User Group - http://www.isug.com Sybase on Linux mailing list: [EMAIL PROTECTED]