How to configure SQL LIKE function?

Question

I want to make a query like this:

create procedure something
  @name varchar(13)
as
begin

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

end

For input, @name=hoI want to output every line containing NAME that sounds ho,

e.g. 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