CONCAT with Different Field Types

[ckiklas]

I am very new to DB2...I can do this in Oracle or SQL Server, but can't quite get the syntax right for DB2.

I need to create a new field based on two other fields.

Field1 = Numeric
Field2 = Alpha (but always contains numbers)

NewField = Numberic ( Field1 and Field2 together)

I tried using:

Field1 Concat Field2
and
Field1 || Field2

Which is when I realized the field types didn't match. Converting the field types is my biggest issue.

Thanks in advance.

-chris.

 

[lespaul]

try this:

char(Field1) || Field2

Leslie