Hello Thomas,

> been wading through quite some past messages, because I suppose this
> question has been asked before- but didn't find anything.
>
> Is there a workaround for the missing LIMIT Keyword in firebird?

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

> I recall, I stumbled over some storedprocedure that emulated LIMIT's
> behavior- but to me it looked very ressource intensive; like still
> querying all the records, but only returning n records (n being an
> input param to the sp).
> Please, correct me if I'm wrong.
>
> Well, maybe someone can come up with a different hint; would be great.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com