Helpful Information
Home
Categories
Contact us
Category: DB2 Development
Numeric Concatenation between SMALLINT and INTEGER ??
Is it possible to concatenate two numeric fields, one with SMALLINT type and the other with INTEGER ?
DO you mean as in string concatenation?
i.e. 2 numbers 123 and 456 you want the result to be
123456?
You would have to do:
CHAR(MyNumericField1) || CHAR(MyNumericField2) As SomeField
fv
privacy (GDPR)