On Saturday 20 January 2007 18:31, jrmrenegade wrote:

> Is there any technique that I can apply to
> "emulate" the LIMIT option for DELETE statements in Firebird?

doesn't the ROWS keyword do that in FB 2.0? From the release notes:

It can be used in unions, any kind of subquery and in
UPDATE or DELETE statements

Example:
DELETE FROM T5
ORDER BY COL5
ROWS 1

--
Wolfgang