Re: Looking for an SQL to append leading zeros

[Peter Levy <plevy@xxxxxxxxxxxx>]

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.
>