>>>I would do RIGHT(ALLTRIM(cField),2) FOR state and SUBSTR(cField,1, LEN(cFiled)-2) for city
>>
>>So do it :)
>
>The key here is that you have to trim the field before you start evaluating it. The second part of your statement without the trim on cField starts its evaluation from the end of the field(including spaces)
>
>Bill
By the way, to give credit where credit is due, you Ed are the one that highlighted the "trim" part of the function. Thanks again!
Bill
CySolutions, Medical Information Technology
You're only as good as your last
success, so . . .If it works. . .don't fix it!