> >> I thought I read somewhere that the latest version of Firebird
> >> supports selecting the first record from a result set, such as this
> >> query in SQL Server:
> >>
> >> SELECT TOP 1 MyColumn FROM MyTable ORDER BY SomeOrd
> >>
> >> Is this true, or am I dreaming it? If it's still a dream, what do
> >> people do for a workaround?

As a workaround, people execute the statement and only fetch the first row.

:-)

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com