请帮小弟我检查一个写法的正确性

请帮我检查一个写法的正确性
create   function   f_str11(@row1   varchar(20))
returns   varchar(400)
as
begin
        declare   @str   varchar(400)
        set   @str= ' '
---主要是看下面这段话.        
        select   @[email protected]+ ', '+scode   from   Standarddata   where   Standardrelated   like   '% '@row1 '% '
-------    
        set   @str=stuff(@str,1,1, ' ')
       
        return   @str
end

我用注释符包起来的那段话是不是错了,正确应该怎么写?
谢谢!


------解决方案--------------------
select @[email protected]+ ', '+scode from Standarddata where Standardrelated like '% '[email protected]+ '% '
------解决方案--------------------
select @[email protected]+ ', '+scode from Standarddata where Standardrelated like '[email protected]% '

------解决方案--------------------
哦，少了两侧的 "+ "号
------解决方案--------------------
select @[email protected]+ ', '+scode from Standarddata where Standardrelated like '% '[email protected]+ '% '