a20213 (4/19/2013)

---

hello, i am trying to make a procedure that returns values if and only the query matches all words .. EX:

declare @Names TABLE

(

name varchar(100)

)

DECLARE @Searchs TABLE

(

word varchar(100)

)

insert into @Searchs (word) select items from dbo.Split('John Andrews', ' ')

insert into @Names values ('John Andrews')

insert into @Names values ('John Adams')

insert into @Names values ('John Matthews')

insert into @Names values ('Mark Snow')

select name,word from @Names

inner join @Searchs on name like '%' + word + '%'

this produces the following result

name word

John AndrewsJohn

John Adams John

John MatthewsJohn

John AndrewsAndrews

my goal is trying to return on 1 result - John Andrews.

what do i need to do to achieve this ?

PS: Is this "procedure" advisable to search multiple words ?

Thank you in advance.