Nando and John,

thanks for the suggestions. But BREAK and FIRST are both only availabe
from FB 1.0 and upper. And some of my customers don't have the latest
FB version.
If I don't find another way the customers will have to upgrade sooner
than I planned to.

Anyway, thank you both,
Markus

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


>The unique value issue notwithstanding this might be a good place to try
>the new Firebird FIRST keyword. The SQL would look something like:
>
>select first 1 key, field from tbl where ... order by ... into :var1,
>:var2.
>
>-John