Whoops, forgot. Using Upper is a good rule of thumb. Even if you don't captialize the company name during data entry, If the index is on Upper(compname), you can find all the "ABC COMPANY".
pf
>Is there a rule of thumb to follow when using index expressions? Is it common to index on something like Upper(AllTrim(FieldName))? Are there performance issues in doing this?
>Any thoughts?
>TIA
(On an infant's shirt): Already smarter than Bush