Hi,

Well you have 3 options:

1) Migrate to Firebird 1.0 as it supports an extension to let you
limit the result set

2) Purchase Interbase 6.5 as it has a similar feature, different
sytax. From what I understand, this feature may not make into Open
source IB for a while or ever for that matter.

3) Write a stored procedure (not sure how, but I have seen it in the
Interbase NG).

HTH


- Lou

--- In ib-support@y..., "Stevio" <redeagle@f...> wrote:
> With InterBase, is there a way to limit the number of records
returned?
>
> What I mean is, if 1000 records match the SELECT statement of the
query, can
> you specify that you only want 100 records returned? If they were
sorted
> alphabetically, you'd want the first 100, with the option to then
get the
> next 100, etc.
>
> How could I do this?
>
> Thanks,
> Stephen