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
midrange.com
