Adding Zeros

  • Thread starter Thread starter Heather
  • Start date Start date
H

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!!
 
You can use the format command, similiar to:

FORMAT([yourValue], "000000")

HTH
DALE
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

adding '00' to a field 4
Regular Expressions -- count lines with a specific pattern in a flat file 2
Zero Upload Speed 6
Adding Zeros 7
Please help to zero filled on file 8
Divide by Zero error 3
sql query reqest 1
delete certain rows 1

Back
Top