We look for names of people (last first).  We never use the leading %, only the trailing %.  So an index is very useful.  I just wonder if using a varchar instead of a char field has an effect on performance.