Microsoft Access Query - I have a list of addresses that import into a table like the following example (Address , City , State):
2785 SUNSHINE WAY , KINSTON , NC
I need to extract the city and was able to get
KINSTON , NC with --
How do I take off the _,NC??