How to adjust SQL LIKE function?
Posted
by slave016
on Stack Overflow
See other posts from Stack Overflow
or by slave016
Published on 2010-03-21T17:57:37Z
Indexed on
2010/03/21
18:01 UTC
Read the original article
Hit count: 175
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...
© Stack Overflow or respective owner