hI,

> I read in the Firebird book to use EXISTS instead of SELECT

COUNT(*)... If

> you just need to see if a record exist.
>
> But the book didn't give an example of it.
>
> Can someone provide me an example of how to construct such a SQL

statement?

>
> Thanks

Go to page 401 of the book it has a good example there.

Apinot