Re: using CONCAT in SQL

I would echo the comment about spelling out the word in general as a habit, 
since cross-platform and remote SQL statement execution is coming to an i5 near 
you..  It's a few keystrokes more, but a little more readable as well.. 

In CL too I have a habit of spelling out *LE and so on, although I might use 
"=" if I'm in a hurry. :)

- Alan 




> Karen -
> 
> I would suggest always using the CONCAT scalar function's name instead of 
> the shortcut || to maintain CCSID compatibility:
> 
> LTRIM removes leading spaces
> TRIM removes trailing spaces
> CONCAT  (alias is ||)
> 
> Example:
> SELECT LTRIM(sddsc1) CONCAT TRIM(LTRIM(sddsc2)) FROM f4211
> 
> Regards,
> Steve
> 


> Karen -
> 
> I would suggest always using the CONCAT scalar function's name instead of 
> the shortcut || to maintain CCSID compatibility:
> 
> LTRIM removes leading spaces
> TRIM removes trailing spaces
> CONCAT  (alias is ||)
> 
> Example:
> SELECT LTRIM(sddsc1) CONCAT TRIM(LTRIM(sddsc2)) FROM f4211
> 
> Regards,
> Steve
> 
> ----- Original Message ----- 
> From: <Peter.Colpaert@xxxxxxxxxx>
> 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.
> >
> > 
> -- 
> 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.
>