Hi all,

How do a parse a field that contains two data elements together (i.e. "MA BOSTON ") into two separate fields with each individual data element for all the records in a table? In VFP, this would be simple:

REPLACE ALL orgcity WITH SUBSTR(orgcitysta,AT(" ",orgcitysta) + 1)

In Access 97, however, I believe I have to write a module which parses the string (using MID$ function??) and call it from an update query.

Any suggestions?

Thanks for your help!

-JT