Remove text from field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
Click to expand...

Back up your table first.

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