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: 172

Filed under:
|
|

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

Related posts about sql

Related posts about sqlserver-2008