Hi All,

We are finally moving up to VFP8 (After our next release, VFP9). I am working with one table at the moment that has a lot of indexes. And I remember seeing here that you should not use alltrims in indexes. I have the following index, which is the longest and worst, that I should probibily fix:

  alltrim(reportedby)+alltrim(takenby)+alltrim(testedby)+alltrim(progname)+ ;
    alltrim(catg_1)+ alltrim(catg_2)+ alltrim(catg_3)+ alltrim(catg_4)+alltrim(str(priority))

I think I can just either do a Padr() leave them alone for the fields that are characters already, but the last field (priority) is a numeric and I have it in about 10 other indexes floating around, not always at the end of the index.
My question on that is do I do a padl() or a padr() on it?

Thanks.
Beth