Hi
3. "starting with" - indexes are used if available

1. and 2. - indexes can't be used.

--- In firebird-support@yahoogroups.com, James <james_027@t...> wrote:
> Hi,
>
> which is better?
> 1. where name like '%chris%'
> 2.where name containing 'chris'
> 3. where name starting with 'chris'
>
> As much as possible I don't want to use the starting with because it's
> not flexible enough in a particular situtation.
>
> Do they use the index if available?
>
> Thanks
>
> regards,
> james