### Title

Add zeros to Numbers

### Post

I am putting a number into a field to get a found set.

The "numbers" in the records are all 6 digets long.

In this file some of the numbers are not that large, so it adds zeros in front to make them 6 long.

The number im imputing is 574.

The file is looking for 000574.

My logict is find the first number that is greater than or equal to... 574.

How do i add 3 zeros to the front of 574 to come up with a number it will recognize.

I tried *574 that got me the number, but in this segment of the file there are 2263 records. That won't work for all situations when my process/script creates a number different than 574. The numbers in the file are not sequential.

Right ( "000000" & yourField; 6 )

A Google seems to think that would work...

Home > Reference > Functions reference > Text functions >

RightRightExamples