You have to do

SET ROWOCOUNT 5

SELECT ...etc

Primitive

There is a hell of a lot that Sybase doesn't seem to do. DBCC SHOWCONTIG, DBCC DBREINDEX etc.

I've been trying to find out a way of defragging indexes and the only way that I have found of doing it is to drop and create the damn things as I had to do in the prehistoric days of SQL 6.5

He was not wholly unware of the potential lack of insignificance.