declare @a int;
declare @b varchar(2);

set @a = 100;
set @b = ' ' + @a  + 2;

select @b;

----
*

 
declare @a int
declare @b varchar(2)

set @a = 10
set @b = ' '
IF ISNUMERIC(@b) = 1
	select @b +@a + 2; 
	
ELSE Print 'Unknown'

-- Even though the following is the result
select @b +@a + 2;

declare @a int
declare @b varchar(2)
set @a = 10
set @b = ' '+@a + 2 
select @a + @b as Original
set @b = ' '*@a + 2 --Multiply instead
select @a + @b as Revised

Original
-----------
22

(1 row(s) affected)

Revised
-----------
12

(1 row(s) affected)