What if you're not combining fields? If you are only indexing on one field, does it make sence to use AllTrim() on that index?. Does it make it easier to use:
seek("ThisData") instead of Seek("ThisData ")?
>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
Alan Trosky
MIS Director
Pennsylvania Bar Association
Harrisburg PA 17108