>>First of all, you should not have an index on alltrim(something), since this will give you a variable expression length. VFP doesn't support this, and it will put an almost arbitrary length (actually based on the first record it finds, I think).
>
>Hilmar,
>This is not true for indexes on normal fields. Because VFP has fixed length fields, the index key will be stored as if a PADR(< alltrim(field value) >,< field width >) was executed on it. Alltrim() has detrimental effects when dealing with memo fields because they are variable length. The first record will determine how long the index key expression will be. Everything after that will be padded or truncated as needed.
That is possible; I am not sure. Anyway, I had problems in the past, and try to avoid variable-length keys as a general principle.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)