split a field 1

[ciarra41]

trying to split theses values into separate fields, there combine in one field.

City&State
ALTUS OK
OKLAHOMA CITY OK
CHOCTAW OK
PERRY OK
Salibury NC

 

[PWise]

Select left(fieldname,len(fieldname)-3) as city ,right(fieldname,2) as state from tablename