add on to existing records

[sueviolet]

I accidently truncated records when appending them to a field (my field size was too small, guess I won't make that mistake again!)

As a result the records that were append are missing a few zero's (to be exact, "00-000") How can I add on 00-000 to my records? (Except where the record value is 0 or null)

Thanks

 

[sueviolet]

point taken