Markus,

> in a trigger I have a select statement like
>
> select Key, Field from Tbl where ...
> order by Field desc
>
> I want to store the value of "Key" in a variable of
> the trigger. But only for the first record.

use a FOR SELECT ... INTO and jump off the loop (is that BREAK?) after
the first occurrence.
Ciao
--
____
_/\/ando