>I read that ALLTRIM on index fields can cause data corruption problems. Is this true? I have ALLTRIMs in many of my applications indexes. And some of the indexes use LTRIM RTRIM to accomplish the same thing. Is this better procedure: INDEX ON LTRIM(RTRIM(CODE_ID))+LTRIM(RTRIM(CODE))TAG ID_CODE
>
>Thanks
>
>Brenda
I've not heard of corruption problems regarding this, but I believe conventional wisdom is to not use trimming in index expressions. You might want to search on this with J. Booth's ID. I believe (but not sure) he has addressed this before.
Bill
William A. Caton III
Software Engineer
MAXIMUS
Atlanta, Ga.