RE: %EDITC function in SQL?

Replace DIGITS() with CHAR().  This gets your minimum requirement, at
least.....

Eric DeLong
Sally Beauty Company
MIS-Sr. Programmer/Analyst
940-898-7863 or ext. 1863



-----Original Message-----
From: rich herdman [mailto:rherdman@columbus.rr.com]
Sent: Thursday, March 28, 2002 8:20 AM
To: midrange-l@midrange.com
Subject: %EDITC function in SQL?


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


_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.