>>>>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
>>>
>>>cString=table1.field1
>>>? substr(cString,len(rtrim(cString))-1,2 )
>>
>>
>>Hmmm, I thought it was a one word function. Must have been that way in another life. Thanks so much for the response.
>>
>>Bill
>
>Ok, take another one:
>? right(alltrim(cString),2)

Now that I think about it, I'll use the first one. I can charge more money for it because it looks more complex!