Replace a single character

[stocktondesigns]

I have a 20,000 + record table, I am viewing the table in Access with has a 20,000 row limit on what I can see. The table contains activation codes, some of the codes have an incorrect character at the beginning, an H should be a B, is there a way that I can run an update that will go through the table replacing the H's with B's? I'm not sure if a search/replace will do it because there are bound to be H's elsewhere in each activation code. Would appreciate tips on how to do this.

Example code:
H2807-Y7F5R-MKTPO-HPRLO
needs to be
B2807-Y7F5R-MKTPO-HPRLO

 

[JohnDTampaBay]

I think should work.

UPDATE table
SET field = 'B' + Right(field, Len(field) -1)
WHERE Left(field, 1) = 'H'

--John
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)