I have a table that I need to update. The field is alphanumeric and goes like
Dc0001
Dc0002
Dc0003
Dc0004
I want to add an extra 0 onto them so would be
Dc00001
Dc00002
Dc00003
Dc00004
As there are a few thousand records like this I don't want to do it manually and just wandered how would I do this in an update query or I would I need some VB code. Thanks for any help
Dc0001
Dc0002
Dc0003
Dc0004
I want to add an extra 0 onto them so would be
Dc00001
Dc00002
Dc00003
Dc00004
As there are a few thousand records like this I don't want to do it manually and just wandered how would I do this in an update query or I would I need some VB code. Thanks for any help