Same problem as RATC(). It evaluates all of the blanks at the end of the field first (since I am looking for the first blank to the left of the last non-blank characters. Thanks for the input.


>Look at the RAT() Function
>
>
>
>
>>
>>My brain must be fried today or something. What is the command to obtain
>the location of the rightmost character(other than a space) in a field.
>Example, a 25 character field with city and state separated by a space
>between city and state. If I grab the last two valid characters in the
>field, I have the state. I can't use the AT function because some cities are
>two words.
>>
>>HELP. I know that this is a no brainer! Thanks everyone
>>
>>Bill