Changing number in a field

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

Guest

I Have a zip code field that has 9 numbes in thefield 12345999 there over a
1000 of these is there a way that I can change just the last number which is
9 to 8 for all the records at one shot?
Thanks
Tom
 
I Have a zip code field that has 9 numbes in thefield 12345999 there over a
1000 of these is there a way that I can change just the last number which is
9 to 8 for all the records at one shot?
Thanks
Tom
Click to expand...

Hmmm. I only see 8 numbers.

Any way, back up your data first.
Create an Update query:

Update YourTable Set YourTable.Zip = Left(Zip,8) & "8" Where
Right(Zip,1) = "9";
 
Back
Top