Friday, February 10, 2012

concatenating columns

I have two columns of type integer that I want to concatenate. I also want to put a "/ " in between the columns.

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