Re: Does DB2/400 have REPEAT function like PLSQL in Oracle?

["Peter Dow (ML)" <maillist@xxxxxxxxxxxxxxx>]

Hi Dave,

If you want to convert it to a character field with leading zeros, use 
the DIGITS(fldname) function.

*Peter Dow* /
Dow Software Services, Inc.
909 793-9050
pdow@xxxxxxxxxxxxxxx <mailto:pdow@xxxxxxxxxxxxxxx> /

Dave Odom wrote:
> Chuck, et al,
>  
> Just to be clear, the data my programmer is accessing is defined as a zoned decimal field in DB2/400.  The field is 9 digits but a normal return from a query does not return the leading zeros which is what she wants.
>  
> If necessary, I think I'll use REXX and SQL since REXX is super at string manipulation.
>  
> Thanks,
>  
> Dave
>