Splitting fields

diagostj

Registered User.
Local time
Today, 16:33
Joined
Aug 12, 2003
Messages
20
I have a pre-existing table that includes city, state, and zip all in one field. Is it possible to separate it into three fields?
 
Update a new field for city using function InStr
Update ZIP field using InStrRev
 
look at split().

Jon
 

Users who are viewing this thread

Back
Top Bottom