Thank yo Alan, it worked just fine, I will study the
IB6 manuals (the only we got for the moment)

--- Alan McDonald <alan@...> wrote:

> >
> > How about:
> >
> > select first 10 skip 0 * from tablename;
> >
> > David
>
> you need an order by here otherwise you will get
> unreliable results
> Alan
>
>
> >
> > ----- Original Message -----
> > From: "Carlos Ortiz Quiros"
> <carlosaortiz@...>
> > To: <firebird-support@yahoogroups.com>
> > Sent: Friday, June 03, 2005 4:50 AM
> > Subject: [firebird-support] Does anybody know???
> >
> >
> > > Does anybody know how to convert the Microsoft
> SQL
> > > Server SELECT TOP 10 * FROM TableName to
> Firebird,
> > > that is, how can I write a query in Firebird SQL
> to
> > > retrieve the first 10 records out 1000 records
> from a
> > > result set.
> > >
> > > Thanks
> > >
> > > Carlos Adolfo Ortiz Q
> > > carlosaortiz@...
> > >
> > >
> __________________________________________________
> > > Do You Yahoo!?
> > > Tired of spam? Yahoo! Mail has the best spam
> protection around
> > > http://mail.yahoo.com
> > >
> > >
> > >
> > >
> > >
>

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

> > >
> > > Visit http://firebird.sourceforge.net and click
> the Resources item
> > > on the main (top) menu. Try Knowledgebase and
> FAQ links !
> > >
> > > Also search the knowledgebases at
> http://www.ibphoenix.com
> > >
> > >
>

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

> > >
> > > Yahoo! Groups Links
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> >
> >
> >
> >
> >
> >
>

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

> >
> > Visit http://firebird.sourceforge.net and click
> the Resources item
> > on the main (top) menu. Try Knowledgebase and FAQ
> links !
> >
> > Also search the knowledgebases at
> http://www.ibphoenix.com
> >
> >
>

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >
>
>

Carlos Adolfo Ortiz Q
carlosaortiz@...

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