DocB1973
asked on
Parsing City and State From One Field
I've read all of the post and I don't think this one has been answered. I have a field that has CITY ST. I need to break them out into two fields. No commas just a space between CITY and ST. I've already done the ST as that was the easy part. Also, the solution needs to be something I can put into a query. Thanks for your help.
ASKER
Thank for the quick reply. It handles everything except when the city has more than one name. Exp: Grand Rapids MI.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Fantasic! Works like a charm.
ASKER
Great job for something you think you know how to do but it turns out it's more difficult than you think.
try this query
select field,left([field],instr([
from tableName