--- Stefan Heymann wrote:

> What is the best and least costly way to check for the existence of at
> least one record in the result set of a SELECT?

I'm but sure about FIRST, but this should do it:

select 1 from rdb$database
where exists ( INSERT_YOUR_SELECT_HERE );

--

Milan Babuskov
http://www.guacosoft.com