At 09:20 AM 17/03/2004 +0000, you wrote:

>Try
>SELECT FIRST 1 KEYFIELD
>FROM SALESDATA
>WHERE (PRODUCT = :someproduct) AND
> (TRANSACTION_DATE >= :somedate)
>
>It's better way IMHO.

No, it isn't. FIRST is a set quantifier and it is applied *after* the
whole set is obtained (like DISTINCT). EXISTS() exits as soon as the first
matching row is established.

Helen