create new field with first 9 characters of old field

[lilpurvis75]

I have a field with a persons ssn# and last name. 555555555Greene I want to
create 2 fields with this data. One with the social 555555555 and one with
the last name Greene. I am guessing that I do this by running a query but not
sure.