Full Text Search ResultS Problem

shore-support
shore-support used Ask the Experts™
on
Using the wildcard '*' character at the start of the search time like *Music to match all the words in  ending in the suffix "Music" i came to know that IFTS doesnt support this property

So my question is suppose i'm doing search on Music .Its give me all the result which starts with the word "music". my problem is i want to have "XPRESSMUSIC" also in my result or where ever in the text word Music is found. if i uses Like operator '%Music%' its gives me all the results which contains Music anywhere  also the Word XpressMusic,

Can any one help me.what should i do to get the XpressMusic when i search For Music.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2011

Commented:
use the patindex function
e.g.

 where patindex('%music%',[text]) >0

Author

Commented:
my friend i didnt get you
my query is like

select A from tbl
where contains(A,'"music*"')

how can i use patindex over here.
Top Expert 2011

Commented:
select A from tbl
where patindex('%music%',A) > 0

Author

Commented:
But i'm talking about full text search and i guess % doesn't work in full text .
Hi i have modified my query  like this

select A from tbl where contains(A,'"music*"') AND  patindex('%music%',A) > 0

But its still giving me the same result and also  there is no change in it.

Author

Commented:
ALso i'm using Full text Index not non clustered index
Top Expert 2011

Commented:
sorry no you cannot  do that wuth fts...

so are reduced to using patindex or Like...

Author

Commented:
since my table size is very long.thats why i have gone for FTS .till now i was using like operator.i dont know hwy sql server is not providing SUFFIX search in FTS
Top Expert 2011

Commented:
i think its more to do with what freetext search is trying to accomplish....

which is basically a "word search in context"

so its dealing with tenses, plurals, and synomyns primarily


if xpressmusic was a proper word maybe you'd have more luck...

you could possibly try adding xpressmusic to the thesaurus?
Top Expert 2011

Commented:

Author

Commented:
hh

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial