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]
