Re: Looking for an SQL to append leading zeros

Try:

select digits(FIELD2) from FILE where FIELD1 IN ('NYC1','NYC2')

donna lester wrote:

Hi

select FIELD2 from FILE where FIELD1 IN ('NYC1','NYC2') The result is

  ------------
78968
5674
330

376543 -------------------------------- FIELD2 is defined as max length of 10 digits. when I run above SQL it gives some rows as shown above where FIELD2 values are less than 10 digits.

Wherever the value of FIELD2 is less than 10 digits , I want to add leading 
zeroes to make it 10 digit number.
  for eg if   FIELD2 of above SQL is 78968
I want to make it as 0000078968 (making it as total 10 digit value).
The result should be as below
  0000078968
0000005674
0000000330
0000376543

Greatly appreciate your help...

Thanks,

Donna.

---------------------------------

Cheap Talk? Check out Yahoo! Messenger's low PC-to-Phone call rates.