RE: Need help with query

["Paul Therrien" <paultherrien@xxxxxxxxxxxxxxxxxx>]

What are you using to get this result?   SQL?  


Paul 

-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Thomas
Burrows
Sent: Saturday, April 18, 2020 1:24 PM
To: RPG programming on the IBM i (AS/400 and iSeries)
<rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: Need help with query

Looking at my screen shot I have two fields need to put together with one
space between. Other than writing a RPG program using a BIF % how can I do
this? Obviously the concatenated field will be just a long Apha.


Results is

FulNAM

JOHN                             DOE



Want

JOHN DOE



Thomas Burrows
--
This is the RPG programming on IBM i (RPG400-L) mailing list To post a
message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com