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