"Nando Dessena" <nandod@...> wrote in message
news:3B85EF1D.AECF86BE@......

> 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?).

The last time I checked, it was FIRST, coupled with SKIP.
:-)

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing