Remove leading zeroes from records in a table. (text field)

[RHONDAK72]

Hello. I use Access 2010. I have a set of records where some values begin with leading zeroes while other values begin with a letter. Can anyone tell me how to remove only the leading zeroes from the records in the table?

Below is an example set of records with Before and then After(what I need for them to become)

BEFORE – This is the data that I pull:

Main.PRID
000123456
000789011
000121314
N00123456
N00123457

AFTER -This is what I want:

Main.PRID
123456
789011
121314
N00123456
N00123457

 

[sunnyland]

Supposing there are 3 zeros at the front, you could run an update query:

UPDATE main SET main.prid = Mid([prid],4)
WHERE (((main.prid) Like "000*"));

Meaning replace string beginning with 3 zero by the same string starting at character 4