Wow...very easy, and quite a quick reply too.

Many thanks!!!!
Kurt.

> --- Helen Borrie <helebor@...> wrote:
>
> At 08:57 AM 15/04/2007, you wrote:
> >Hi.
> >
> >While migrating queries with a row limit, I noticed
> Firebird errors
> >with a unknown token error where "limit" occurs.
> >
> >For example, "select * from data order by date desc
> limit 200" to pull
> >only the LAST 200 rows entered.
> >
> >Is there a Firebird equivalent I can use to keep
> queries from
> >returning 10000 rows when I only need a few??
>
> SELECT FIRST 200 from data order by date desc
>
> You can also use a SKIP n clause to begin fetching
> from the (n+1)
> record in the set.
>
> For this syntax see the v.1.5.4 release notes.
>
> V.2.0 introduces the SQL 200x syntax for a similar
> thing: refer to
> the ROWS syntax in the the v.2.0.1 release notes.
>
> ./heLen
>

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com