Is there a way to replace the first 5 numbers in each cell with 9999?

[Bob Fitz]

tng73
Sorry I forgot about the ; at the end of the code I posted. That would need to be put at the very end of the line, so you would then have:
UPDATE YourTableName SET YourTableName.YourFieldName= "99999" & Mid([YourFieldName],6) WHERE [YourFieldName] Not Is Null;