Hello All, I am sure there is a way to do this but I haven't figured it out yet. I have over 3000 records of street names that look like this;
"ALLEYS MILL RD - RTE 4" I would like to run a query or an update column routine that would split the column at the "-" (dash) and update column1 with "Alleys Mill Rd" and column2 with "RTE 4". Is there a simple way to do this? TIA. Steve
