Hi Chuck,
Technically, you don't have to do that for the field, assuming that EXACT is off. The way I described is just a preference for me.
HTH,
Brian
>I did that, but my question remains WHY having to need to do that for the FIELD?
>
>m.lo1 = "ma " so ALLTRIM(UPPER(m.lo1)) makes it "MA"
>
>and
>
>should find
>"Grandma Smith"
>"Grandma Smith "
>" Grandma Smith"
>"Grandma Smith"
>
>Right?
>