Remove text from field

[cvegas]

I would like to run an update query and remove everthing to the right of the
comma in a particular field. (Actually I want to remove the comma and
everthing to the right of the comma)

IE: San Francisco, CA
Los Angeles, CA

Result San Francisco
Los Angeles

Help with syntax would be greatly appreciated.

 

[fredg]

I would like to run an update query and remove everthing to the right of the
comma in a particular field. (Actually I want to remove the comma and
everthing to the right of the comma)

IE: San Francisco, CA
Los Angeles, CA

Result San Francisco
Los Angeles

Help with syntax would be greatly appreciated.

Back up your table first.

Update YourTable Set YourTable.CombinedField =
Left([CombinedField],InStr([CombinedField],",")-1);