Remove text from field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

cvegas - 07 Oct 2004 16:25 GMT

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.

Reply to this Message

fredg - 07 Oct 2004 17:17 GMT

> 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
[quoted text clipped - 7 lines]
>
> Help with syntax would be greatly appreciated.

Back up your table first.

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

Signature

Fred
Please only reply to this newsgroup.
I do not reply to personal email.

Reply to this Message