> What is the best way to get only the first record occurence
> of a query?
> (and not reading the rest of the records)

Download the Firebird v1. beta and use the new SELECT FIRST x syntax.


Sean