Hi all,

I know, I know, I should be posting this on the MS Office/Access forum but I thought I'd give my fellow VFPers a try first.

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 helping a fellow Foxer figure out this cryptic Access thing!

-JT