Mike,

> 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?).
Ciao
--
____
_/\/ando