> In mssql u can write
>
> select top fieldname from table where x=y order by fieldname desc
>
> is there something like that in firebird?

SELECT FIRST 1 FIELDNAME ...

( This is on FB1 isn't it :) )

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services