On Thu, 28 Aug 2003 06:42:55 -0700, Alison wrote:

> Is there a way to limit the number of rows returned in a select statement?
>
> I thought it was TOP(5) but that does not work..

Look up the "SET ROWCOUNT xxx" command in the ASE reference manual.

Michael
--
Michael Peppler Data Migrations, Inc.
mpeppler@peppler.org http://www.mbay.net/~mpeppler
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or
long term contract positions - http://www.mbay.net/~mpeppler/resume.html