Re: Need help with query

[Doug Davie <dougdavie@xxxxxxxxx>]

*bcat

On Sat, Apr 18, 2020, 1:33 PM Paul Therrien <paultherrien@xxxxxxxxxxxxxxxxxx>
wrote:

> 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
>
> --
> 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