如何调整SQL LIKE功能？

Question

我想做这样的查询：

create procedure something
  @name varchar(13)
as
begin

  select * 
   from WORKER
  where NAME LIKE "%@name%"

end

对于输入@name=ho，我希望输出包含听起来ho的NAME的每一行，

例如HOuse、soHO、broHOw。 ..

Answer 1

Select * from WORKER where Name Like '%' + @name + '%'

Answer 2

create procedure something
@name varchar(13)
as
begin
select * from WORKER
where NAME LIKE '%' + @name + '%'
end