Jakob Braeuchi wrote:
DB2 is completely different:
'OJB.' concat rtrim(char(col1)) concat rtrim(char(col2))
does db2 support || as concatenation character ?
I did not verify it, but https://aurora.vcu.edu/db2help/db2s0/ch2func.htm#TBLFUNTBL
claims that '||' is equivalent to 'concat'. Note, that I've had problems with the casting
operation, as it returns a left aligned string of a fixed size - lots of spaces, that you might
not want.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
