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