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