Hi,

At March 5, 2004, 13:21, HBK wrote:

> Best way of limiting returned number of rows ?

Yes.

> Can "Where ROW_COUNT < 1000" be used to limit returned number of records
> if query returns > 1000 ?

> Or are there better ways of doing this ?

With Firebird, you can do: SELECT FIRST 1000 * FROM Table

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)