I have a very large database that I need to be able to sort by state.
Unfortunately, whoever put the database together including city,state,zip all
in the same column. Is there any way that I can still sort by state without
retyping (retyping is not an option bc there are over 7000 entries)?