in semantic database want to get rank of every word in conat

Question

sPlease help me............................................


In semanctic databse

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]


above code fetches the rank of complete string when string str is passed to function CONTAINSTABLE.
but I need it separates all the words and fetches the rank of all the words. Separator should be 'AND' or 'OR'.
output should be in format of commseperated rank with every word like this


seperator and ,or

word rank
java 23
sql 21
unix devloper 20
php 30
fox devloper 23

Improve question Permalink