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
Jeff Trockman, MCP