Re: SQL convert count to char

Thanks to both Eric and Roger for your help. Both solutions work. Once
again this list provides quick answers. Thanks again.

Dean Eshleman,
MMA, Inc.

On Thu, 9 Sep 2010 10:42:06 -0500, in midrange.midrange-l you wrote:

Use the DIGITS() function.

Select DIGITS(DECIMAL(mycount,8,0))

From ...

Hth,
-Eric DeLong

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
Dean.Eshleman@xxxxxxxxxxxxxx
Sent: Thursday, September 09, 2010 10: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.

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