Concatenating int values to form a computed int column

[nelco]

Hi,

I want to create a computed column which concatenates other int column values.

Ex. The table has these columns:
ID int (computed Column), ContentTypeID int, MatchTypeID int

If the values for ContentTypeID, MatchTypeID are:
ContentTypeID, MatchTypeID
1 2
Then ID column should have the value 12

What should the expression be to get the computed column?

Thanks in advance!

 

[RiverGuy]

CONVERT(VARCHAR(11), ContentTypeID) + CONVERT(VARCHAR(11), MatchTypeID)

Be aware that if you allow negative numbers, your concatenation could look like of weird. For example -1-2