> >For exmaple if I had a table called table1 that contained 10,000
> >records and I wrote a query of : select field1, field2 from

table1.

> >This obviously will return all of the records, but what I want to

do

> >is have that query but reduce the result set to say ten records.
>
> select first 10 field1, field2 from table1.
>

Brilliant!!! Exactly what I'm after, I don't mind doing a minor
change like that, I can dynamically change the query on the fly.

Regards,
Marcus.