Re: Syntax for concat in sql

You can only concatenate character variables. If you're using numeric, date,
etc., you need to convert those to chars using the appropriate scalar
function. ie: CHAR or DIGITS.

This is all clearly documented in the SQL Reference:

http://as400bks.rochester.ibm.com/pubs/html/as400/v4r5/ic2924/index.htm?info
/db2/rbafzmst02.htm



John Taylor


----- Original Message -----
From: "Giri Gopal" <GiriGopal@bcginK.com>
To: <rpg400-l@midrange.com>
Sent: Friday, August 31, 2001 08:17
Subject: Syntax for concat in sql


> Hello:
>
> I am trying to concat 3 fields of different data type. Is this possible in
> SQL syntax. I am not able to do concat even on a command line. I get
syntax
> error. Can some please tell me what the proper syntax is.
>
>
> Thanks for your help in advance.
>
> GG
>