想请教一下模糊查询的sp如何写

想请问一下模糊查询的sp怎么写？
比如
@name是变量，字段name需要模糊匹配
select     *   from   person   where   name   like  
后面怎么写呢？
谢了

------解决方案--------------------
select * from person where name like '% '[email protected]+ '% '
------解决方案--------------------
exec( 'select * from person where name like ' '% '[email protected]+ '% ' ' ')
------解决方案--------------------

select * from person where name like '% '[email protected]+ '% '
------解决方案--------------------
declare @str nvarchar(40)
set @str= 'zh '
select * from a where fmemo like '% '[email protected]+ '% '
------解决方案--------------------
CREATE PROC PS_TEST
@NAME NVARCHAR(20)
AS
BEGIN
SET NOCOUNT ON

SELECT * FROM person WHERE [name] LIKE '% '[email protected]+ '% '

SET NOCOUNT OFF
END
GO

EXEC PS_TEST '义 '

DROP PROC PS_TEST
------解决方案--------------------
select * from person where name like '%[ '[email protected]+ ']% '
------解决方案--------------------
declare @name char(10)
set @name= '123 '
print( 'select * from person where name like ' '% '+ltrim(rtrim(@name))+ '% ' ')
先把得到的语句print出来
------解决方案--------------------
@AppName char(20)=null,


改為

@AppName varchar(20)=null,