--- In firebird-support@yahoogroups.com, "yartax1" <yartax@...> wrote:

>
> Hi,
>
> One question, did fb 1.5 benefits of indexes with udf functions?
>
> Example:
>
> I have next query:
>
> Select *
> from table A
> where substr(a.zone,1,4) = 'EUR_'
>
> with a index on a.zone

Select *
from table A
where a.zone starting with 'EUR_';


Adam