Re: using CONCAT in SQL

Karen -

LTRIM removes leading spaces
TRIM removes trailing spaces
CONCAT  (alias is ||)

Example:
SELECT LTRIM(sddsc1) CONCAT TRIM(LTRIM(sddsc2)) FROM f4211

Regards,
Steve

To: "RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx>
Sent: Tuesday, June 14, 2005 1:03 AM
Subject: Re: using CONCAT in SQL

Karen,

depending on your CCSID (I think), you may need the ! (exclamation mark)
instead of | (pipe character).

HTH,

Peter Colpaert
Application Developer
Massive - Kontich, Belgium
-----
Yoda of Borg are we.  Futile is resistance, assimilated will you be.
-----




Karen L Hodge/MIS/Genesys <KHodge@xxxxxxxxxxx>
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
13/06/2005 17:46
Please respond to RPG programming on the AS400 / iSeries


       To:     rpg400-l@xxxxxxxxxxxx
       cc:
       Subject:        Re: RPG400-L Digest, Vol 4, Issue 662






Don't mean to be a pest, but I tried |< and |> without success (in both
QUERY and SQL)

What release is that allowed in?

message: 8
date: Mon, 13 Jun 2005 08:27:46 -0700 (PDT)
from: Jeffrey Young <cooljeff913@xxxxxxxxx>
subject: Re: Using Concat in SQL

You use the ||, |< or |> symbols.

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



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