Re: Looking for an SQL to append leading zeros

[donna lester <donna_lester_ny@xxxxxxxxx>]

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.