%EDITC function in SQL?

["rich herdman" <rherdman@xxxxxxxxxxxxxxx>]

Does anyone know of a way to format a number in an SQL statement (similar
to the %EDITC BIF in RPG4)?


Here is what I am trying to do:  I am using SQL to insert records into a file,
and then emailing the contents of that file to various people.  Here
is my SQL statement:

"INSERT INTO QTEMP/MSG
select 'Records in file:  ' || DIGITS(count(*)) from lib/file"


Here's the record it write to my file:

"Records in file:  0000011862"


Is there any way to do some formatting to that number?  I'd like
to remove the leading zeros at a minimum, and inserting commas would
be helpful.  Any suggestions?

Rich Herdman
Abbott Foods
Columbus, OH
email: rherdman@abbottfoods.com