>>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!
CySolutions, Medical Information Technology
You're only as good as your last
success, so . . .If it works. . .don't fix it!