RE: RPG400-L Digest, Vol 4, Issue 662

|< and |> don't work in SQL.


That's just for CL.

In SQL you need to use the TRIM function.

SQL does allow || to be used for concatenation.  But you are better off using 
the CONCAT function.

HTH,

Charles Wilt
--
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
 

> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of Karen L
> Hodge/MIS/Genesys
> Sent: Monday, June 13, 2005 11:47 AM
> To: rpg400-l@xxxxxxxxxxxx
> 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.
> 
>