> I'm converting an app from MySQL to FB. One of the bothersome issues is
> syntax.
> MySQL has the LIMIT modifier which takes a numeric argument, limiting
> the number of rows retuend by a query.
> MSSQL has an equivalent in TOP. does Firebird have anything like this?

select * from foo
where ...
rows n to m

or

select first n skip m from foo
where...
(this syntax is older, if you are using version 2 or above, use rows)

Sasha