Access 2000 Update Query

In a database I have a field that has a full address in it and would like to remove the City where the format appears like this;
Somewhere, MA 01609
Some, MA 01609
I know that the update line statement in the query “Left([FieldName],”10″)” retains the first 10 characters but would like to know the
Statement that would retain characters up to the comma.