Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ronin2307
Posting Yak Master
126 Posts |
 Posted - 2007-04-24 : 17:28:31
|
| hi,I have a SP in which I try to utilize the freetext predicate on a text column that i want to make searchable.to make this less complicated, because this won't be the only field i search by, i would like to be able to use a wildcard on the text column so that ALL results are returnedsomething like Select * from TblTest where freetext(colTest, '*')I would like to return all results from the tableI know that the * is the wildcard unlike % for LIKE statements, but this seems to be wrong since i get this:Execution of a full-text operation failed. A clause of the query contained only ignored words. is there any way to make this work |
|
|
cvraghu
Posting Yak Master
187 Posts |
Posted - 2007-04-24 : 18:58:10
|
| You cannot use wildcards with FREETEXT. Also, i believe, you cannot modify the noise file to allow such query. May be someone else have to confirm. You may have to redesign your logic.Use of WEIGHT, FORMSOF, wildcards, NEAR and other syntax is not allowed. freetext_string is wordbroken, stemmed, and passed through the thesaurus. If freetext_string is enclosed in double quotation marks, a phrase match is instead performed; stemming and thesaurus are not performed. No special meaning is given to any of the reserved keywords or wildcard characters that typically have meaning when specified in the <contains_search_condition> parameter of the CONTAINS predicate |
 |
|
|
|
|
|
|
|
full-text wildcard