>>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
>
>Do you use VB5 or VB6?
>
>If you use VB6, you now have the Replace function.
>
>If you use VB5, you have to play with INSTR and MID to replace characters.
>Tell me if you use VB5 and I will give you a code snippet that does this.

I have VB6 but I'd prefer to stay in Access '97.

-JT