RE: AS/400 app FTPs file to IFS???

Loyd

You can right-justify (generally) by

substr(cast(' ' as char(n)), 1, n - length(strip(fieldname,b,' ')) ||
strip(fieldname,b,' ')

where "fieldname" could also be "char(numericfieldname)" or any other
expression that yields a string.

The

At 11:39 AM 11/6/2002 -0600, you wrote:

I come close with this SQL:

select
cast('AAAA' as char(4)) concat
cast(char(-11.23) as char(11)) concat
cast('Some text' as char(20)) concat
x'0d25'
from QSYS2/QSQPTABL

gives

String Expression
AAAA-11.23     Some text           <crlf>

Substitute your file and field names...
I didn't see how to right jusify the number, however...

Once this works, you could to a CPYTOSTMF as suggested.

HTH,
Loyd