shore-support
asked on
Full Text Search ResultS Problem
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.
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.
ASKER
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.
my query is like
select A from tbl
where contains(A,'"music*"')
how can i use patindex over here.
select A from tbl
where patindex('%music%',A) > 0
where patindex('%music%',A) > 0
ASKER
But i'm talking about full text search and i guess % doesn't work in full text .
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
ALso i'm using Full text Index not non clustered index
sorry no you cannot do that wuth fts...
so are reduced to using patindex or Like...
so are reduced to using patindex or Like...
ASKER
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
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?
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?
here is how to find and supplement a thesaurus
http://arcanecode.com/2008/05/28/creating-custom-thesaurus-entries-in-sql-server-2005-and-2008-full-text-search/
http://arcanecode.com/2008/05/28/creating-custom-thesaurus-entries-in-sql-server-2005-and-2008-full-text-search/
ASKER
hh
e.g.
where patindex('%music%',[text])