Re: Looking for an SQL to append leading zeros

This  does nt work for me.
  I want to update FIELD2 with leading zeroes wherever it finds a value less 
than 10 digits.

Peter Levy <plevy@xxxxxxxxxxxx> wrote:
  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.