At 08:38 AM 18/11/2003 +0200, you wrote:

>How can I tell firebird to return only a set amount of records ?
>SELECT * FROM People ; Returns 70000 records but I want to return only the
>first 100 ?

"First 100" implies that the set must be ordered...

do

SELECT FIRST 100 * FROM People
ORDER BY <something sensible>

You can do this too:

SELECT FIRST 100 SKIP 100 * FROM People
ORDER BY <something sensible>

to get rows 101 to 200 of the set.

heLen