Hi Normn,

> I'm converting an app from MySQL to FB. One of the bothersome issues is

syntax.

> MySQL has the LIMIT modifier which takes a numeric argument, limiting the

number of rows retuend by a query.

> MSSQL has an equivalent in TOP. does Firebird have anything like this?
> Obviously, one is inclined to think of the WHERE clause, but since you are

not certain of what you're going to get back, until you've gotten it, it is
not always possible to limit on the basis of the WHERE clause.

> Any suggestions as to how to overcome this problem?

SELECT FIRST [n] [SKIP [m]]
...


As per Release Notes ;-)

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