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
(On an infant's shirt): Already smarter than Bush