remove portion of data

  • Thread starter Thread starter harvey
  • Start date Start date
H

harvey

I use access 2000. In field entitled city, I have the
following data examples:

Brooklyn ORIG. MTG & AMT:
East Rockaway
N. Bellmore ORIG. MTG & AMT:

Using an update query, is there a way to remove ORIG. MTG
& AMT: from about two hundred of eight hundred records.
 
You might do this using a query whose SQL looks something like this:

UPDATE
[Your Table]
SET
[Your Table].city = Left([Your Table].city, Length([Your
Table].city)-Length(" ORIG. MTG & AMT:"))
WHERE
[Your Table].city Like "* ORIG. MTG & AMT:"
 
Back
Top