Hi,

> I guess you could something like
>
> DELETE FROM YourTable
> WHERE YourField IN
> (
> SELECT FIRST 100 YourField FROM YourTable
> WHERE <your Condition>
> );

Note that this will delete _ALL_ rows if <your condition> contains an equal
comparision between de the sub-query and base-query, because for every
record of YourTable the sub-query is executed.


Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Firebird links :
http://www.firebirdsql.com
http://www.firebirdsql.info
http://www.fingerbird.de/
http://www.comunidade-firebird.org/


Nederlandse firebird nieuwsgroep :
news://80.126.130.81