Changing number in a field

[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

 

[fredg]

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

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";