RE: SQL convert count to char

["Morgan, Paul" <Paul.Morgan@xxxxxxxxxxx>]

Dean,

Use the DIGITS() and SUBSTR() SQL built in functions:

SUBSTR(DIGITS(count),offset,8)

If your count is less than eight digits you might have to CONCAT some leading zeros.

Paul

Principal Programmer Analyst
IS Supply Chain/Replenishment

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Dean.Eshleman@xxxxxxxxxxxxxx
Sent: Thursday, September 09, 2010 11:30 AM
To: midrange-l@xxxxxxxxxxxx
Subject: SQL convert count to char

Hi,

We have a requirement to update a character field with the count of the 
records in the file.  The count needs to be right justified in the 
character field and contain leading zeros.  The length of the character 
field is 8.  I know how to get the count with an SQL statement, but how 
can I convert that count to character with leading zeroes?  Is this even 
possible in SQL?  We are on V5R4.

Dean Eshleman
MMA, Inc.

______________________________________________________________________
Confidentiality Notice: This information is intended only for the individual or entity named. If you are not the intended recipient, do not use or disclose this information.  If you received this e-mail in error, please delete or otherwise destroy it and contact us at (800) 348-7468 so we can take steps to avoid such transmissions errors in the future. Thank you.