请教一个简单语句的写法!!!!!!!!!!在线等待!

[kangway]

下面是一个存储过程中的一条语句,我将其最简化了，以便大家能容易看明白.
declare @i nvarchar(50)
set @i='%上海%'
exec('select Top 100 * from Table where Name like ' + @i )

现在问题是，这语句测试能通过，可在执行时报错,

服务器: 消息 170，级别 15，状态 1，行 1
第 1 行: '上海' 附近有语法错误。

我该怎样写?谢谢!

[lsxaa]

set @i=N'%上海%'

[Andy__Huang]

declare @i nvarchar(50)
set @i='%上海%'
exec('select Top 100 * from Table where Name like ''' + @i +'''')

[WangZWang]

exec('select Top 100 * from Table where Name like'''+@i+'''')

[freddy2003]

declare @i nvarchar(50)
set @i='%上海%'
exec('select Top 100 * from Table where Name like ''' + @i+''' )

[freddy2003]

declare @i nvarchar(50)
set @i='%上海%'
exec('select Top 100 * from Table where Name like ''' + @i+'''' )

[clavier]

declare @i nvarchar(50)
set @i='''%上海%'''
exec('select Top 100 * from Table where Name like ' + @i )

[kangway]

ok,解决了，谢谢大家，马上给分!!!!!

[F15Eagle]

declare @i nvarchar(50)
set @i='%上海%'
exec('select Top 100 * from Table where Name like ''' + @i +'''')