set @str='java and sql and unix devloper or php and fox devloper' SELECT K.RANK, AddressLine1, City FROM Person.Address AS A INNER JOIN CONTAINSTABLE(Person.Address, AddressLine1,@str) AS K ON A.AddressID = K.[KEY]
CONTAINSTABLE
AND
OR
word rank java 23 sql 21 unix devloper 20 php 30 fox devloper 23
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)