Subject Re: [ib-support] DISTINCT
Author Nando Dessena

> what I am wanting to do is just get the first record that matches a query.

then I don't think that DISTINCT will be of any help.
If I remember well you are using the latest Firebird; if this is the
case, you can try TOP (or was it FIRST?).