Adding Zeros

[Heather]

I need to create an expression that adds zeros to the
front of field. The data looks like this;

Have Need
7 000007
22 000022
333 000333
1231 001231

Any suggestions? THANKS!!

 

[Dale Fye]

You can use the format command, similiar to:

FORMAT([yourValue], "000000")

HTH
DALE