At 09:32 AM 16/09/2003 +0200, you wrote:

>Hello
>
>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 from table
where x=y
order by fieldname desc

Have you thought about reading the release notes?

heLen