RE: Need help with query

["Steinmetz, Paul" <PSteinmetz@xxxxxxxxxx>]

Define Result Fields - Help

Character Expression Example:  If FIRSTNAME and LASTNAME are       
character fields, you can define a character result field FULLNAME 
by typing FULLNAME in the Field column and typing the expression   
'Dr. ' || FIRSTNAME || LASTNAME in the Expression column.  When the
query is run, Query combines Dr. with the first name and last name 
from each selected record to produce the full name value in the    
FULLNAME result field.           

                    Character concatenation:                         
         Syntax for:     value-1 || value-2      
         Example of:     ALPHASTR  || 'xyz123'   
    If field ALPHASTR contains DEF, the resulting
    concatenation is DEFxyz123.                                

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