>>
>>Isn't there also an issue with concatenated field indices with alltrims. So, indexing on something like "alltrim(lastname) + alltrim(firstname)" will result in a variable length index, right? I'm almost certain that that was the case a few years ago...
>
>I don't think that's a problem anymore. I think your index would be the length of the untrimmed fields, but I'm not sure. I think it may have been a problem in the past, but I think it's dealt with now.
Cool. I guess periodically I should re-try all the stuff that used to burn me (in VFP, VB, SQL Server) to see if, finally, those MS engineers have made the compiler "do what I meant, not what I said" <bg>
Then again, that's a pretty long list....
The whole problem with the world is that fools and fanatics are always so certain of themselves, but wiser people so full of doubts. - Bertrand Russell