If the right 2 characters are *always* the state, just use:

right(alltrim(field1),2)