Hi Charlie --

Why use the ALLTRIM in the first place? It really won't speed anything else, but I do agree with the UPPER(), especially if you're not sure the case of the data going into the field.


>
>Yeah, I'm using ALLTRIM(UPPER(somekey)), is that why the TRIM is ignored? I'm also using UPPER() in the search expression. I figured using UPPER() on both sides of the expression would speed things up because the index sorting order is case sensitive.
>
>Someone suggested padding the search expression to match the field width if it is not a field. That makes sense.
>
>Thanx,
>Charlie