Hi Charlie ---

No they are not; something else must be going on. For example, if I have an index on TRIM(lastname) and then SEEK "Koziol" there shouldn't be a problem. Perhaps you are using UPPER or LOWER in the index expression or in the SEEK expression?


>
>If I have an index on some field and the expression I'm searching for using SEEK() has leading or trailing blanks, I don't get a match. If I try an alltrim on the search expression and the index key, I still don't get a match. I appears that TRIM commands are ignored in index expressions.
>
>Charlie