Software

Ask something
Discussion Locked

Access 2000 Update Query

0 helpful
6 replies

by devmann

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

6 replies

by devmann

The reason i ask "remove characters up to the comma was because I have data that also looks like this; Somewhere,MA 016091234 and Somewhere, MA 016091234 where ther is a space bewteen the state and the Zip code.

This discussion is closed to new replies.