>>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
>RIGHTC()?

Wished it was. RIGHTC() starts from the end of the field (all 25 characters) and evaluates all the blanks. I need to start counting from the last character other than the space. Ed Pikman came up with the command stream. Thanks for your input!