--- In firebird-support@yahoogroups.com, "Ann W. Harrison"
<aharrison@i...> wrote:

> At 07:11 PM 11/30/2004, GrumpyRain wrote:
>
> >But how could that index help if your query went something like
> >
> >select name
> >from employee
> >where name like '%i'
> >
> >By inspecting 1 by 1, we know it is only Adrian and Martin, but the
> >index can't help on this.
>
> Actually, that wouldn't find any matches, though it would
> match Bobbi or Terri.
>
> Cheers,
>
> Ann

LOL, my brain must be at home today.

select name
from employee
where name like '%i%',

Now the comment makes sense.

Adam