Thanks Cindy:
I have been reading the help files for the past 5 days and trying to find solutions using any of the 'Trim' functions to produce the results I needed. I must be missing something since Larry's suggestion:
Try right(rtrim(lastname),3)
did not appear in the help files I was looking at.
I could not find any help examples suggesting using the word 'right' before 'rtrim'.
I think at times my experience with Access is confusing my efforts to understand expressions in FoxPro. So far I'm finding that trying to apply Access expressions to FoxPro is making things too complicated. It appears that FoxPro expressions are much more refined and to the point.
Thanks
Peter
Ask a question, risk being a fool for a moment. Don't ask the question be a fool for life. (unknown)