I have tried doing it in the same way as I would for varchar columns but that doesn't seem to work for integers.
Thanks
RupalDo the following
SELECT ComputedColumn = Cast(column1 as varchar(4)) + '/' + Cast(column2 as varchar(4))
FROM TableName|||
SELECT (CONVERT(varchar,t.int1) + '/' + CONVERT(varchar,t.int2)) AS concatedcolumn
FROM table1 t
No comments:
Post a Comment