i have these table 

ModelTable :
Code         Description
1FMRE11W     CLUBWAGON 4X2
1FMRU15W     EXPEDITION 4X2  
1FMZU77E     EXPLORER 4X4

 



VehicleTable :

       Vin                   Model
1FMRU15W01LA49512              
1FMRU15W21LA64339
1FMRU15W81LA64331
1FMRE11W91HB74164
1FMRE11W41HB74153
1FMZU77E01UC60281
1FMZU77E02LA32865



 
I want to update the model column of VehicleTable by just reading to the modeltable.



Example if vin like '1FMRE11W%' then update modeltable with CLUBWAGON 4X2
.
.
.
vin like '1FMRU15W%' then   EXPEDITION 4X2  






here is my code :




declare @ssql varchar(800),@code varchar(300)
declare @ctr integer
set @ctr=0
while @ctr < (select count (code) from model)

begin
 set @ctr=@ctr+1
 set @ssql = 'update vehicletable set model = (SELECT TOP 1   description FROM modeltable WHERE code in (SELECT TOP ' + convert (varchar(3),@ctr) +
	 ' code  FROM modeltable ORDER BY code DESC) ORDER BY code ASC) where vin like '   

set @code = ' SELECT TOP 1 code FROM modeltable WHERE code in (SELECT TOP ' + convert (varchar(3),@ctr) + ' code  FROM modeltable ORDER BY code DESC) ORDER BY code ASC' 

set @ssql = @ssql + @code + '%'


exec(@ssql)
end


im getting an syntax error when I want to put '%' at the end of my like statement ... I want it to be dynamic...
pls. help