SQLSERVER: 'Concat' in SQL SERVER 2008

Example

Select a.* 
from testa a
Where (cast( a.column1 as varchar) +cast(a.column2 as varchar))    in (select  cast( b.column1 as varchar) +cast(b.column2 as varchar)  from testb b)