Big rule of thumb, or just a plain ole' big no-no is to use Trim in indexes. Foxpro does not work with variable length indexes.

Example

Column 1 Column 2
"10" "1"
"1" "01"

If you have index of trim(column1) + trim(column2), both index keys from above will be "101".

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