请教！急中！
DECLARE @chrsql char(1000),@Warehouse char(1000)
set @Warehouse= '工程 '
set @Warehouse = '% '+@Warehouse+ '% '
set @chrsql= 'select * into tempdb..table_csyy from tempdb..table1 '+ ' where '+ ' 仓库名称 '+ ' like '+char(39)+@Warehouse+char(39)
print @chrsql
结果为：
select * into tempdb..table_csyy from tempdb..table1 where 仓库名称 like '%工程
为什么后面的没有成功连起来
结果应该是：
select * into tempdb..table_csyy from tempdb..table1 where 仓库名称 like '%工程% '
[解决办法]
DECLARE @chrsql char(1000),@Warehouse char(1000)
set @Warehouse= '工程 '
set @Warehouse = '% '+rtrim(@Warehouse)+ '% ' ' '
set @chrsql= 'select * into tempdb..table_csyy from tempdb..table1 '+ ' where '+ ' 仓库名称 '+ ' like '+char(39)+@Warehouse
print rtrim(@chrsql)
