Hi,
it is not free but cheapest, if there is an index on ADate field.

... where ADate between DSTART and DEND ..
isn't more clear?

Regards,

-Ali

--- In firebird-support@yahoogroups.com, Bambang P <bpranoto@g...>
wrote:

> In this stored procedure statement:
>
> if (exists(select 1 from HOLIDAYS where ADate>=DSTART and

AData<=DEND))

> then begin
> .....
> end
>
> Question:
>
> Does the select statement step through all records which meet the

condition

> or does it return immediately after the first occurance of the

condition?

>
> TIA,
> --
> Bambang P.