Hi all, my english is very bad, so i try to explain...
when i put the string
and Contains (PG.GenericTitleFullTxt,'"* Dias *" AND "* que *"AND "* Abalaram *" AND "* Mundo * "')
in my query, the results show up.... but is only i put the " * O * " in the search string and not shows ..something linke
and Contains (PG.GenericTitleFullTxt,'"* Dias *" AND "* que *"AND "* Abalaram *" AND "* O * " AND * Mundo * "')
All the conditions for the "and" exists....in my catalog i have the string
Dias que Abalaram O Mundo
many times..bu if i put the "O" in the search ...not shows nothing...
I droped the catalog, indexes..rebuild..etc...
Anyone can help me ?
Thanks..
First of all, you should leave the blank before and after the words, as the word breaker has already broken the words in the database to small pieces which can be recognized. if the words you are searching for are all single words you should also leave the * signs due to the same reasons mentioned above.Jens K. Suessmeyer
http://www.sqlserver2005.de
没有评论:
发表评论