sql - 如何调整SQL LIKE 功能？

Question

我想做这样的查询:

create procedure something
  @name varchar(13)
as
begin

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

end

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

例如 HOuse、soHO、broHOw...

Answer 1

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