How to adjust SQL LIKE function?
- by slave016
I want to make this kind of query:
create procedure something
@name varchar(13)
as
begin
select * from WORKER
where NAME LIKE "%@name%"
end
For input @name=ho, I want output every row that contains NAME wich sounds "ho",
for example HOuse, soHO, broHOw...