Remove zeros within a number string

[catguy]

This should be simple, but I think my brain has taken the rest of the day off. I have a column of nine digit numbers (200000626) and need to remove the first 3 zeros to reduce it to a 6 digit number (200626).
I plan on using an update query to accomplish this, but just can't seem to find the the correct function.

[RuralGuy]

Try: Left([YourField],1) & Mid([YourField],5)

[catguy]

Worked like a charm. Thanks

[RuralGuy]

Glad I could help.