请教怎么insert的时候插入百分号

请问如何insert的时候插入百分号
请问我要插入一条语句

SQL code

insert into final exec('select value  from store_temp where number = '+@colnumber+' - 1')

SQL code

insert into final select ltrim(value)+'%' from store_temp where number =@colnumber-1
[解决办法]
SQL code
insert into final exec('select rtrim(value)+''%''  from store_temp where number = '+@colnumber+' - 1')
[解决办法]
SQL code
--tryinsert into final exec('select value+''%''  from store_temp where number = '+@colnumber+' - 1')
[解决办法]
什么地方涉及到了百分号？