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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-09-17 : 10:25:36
|
| Rich writes "I have a SP that contains the following line of code: SELECT RELSTRNG, ADVERTISERID FROM relevancy WHERE CONTAINS(RELSTRNG, ' FORMSOF (INFLECTIONAL, @R0, @R1, @R2, @R3, @R4, @R5 ) ')I have noticed that microsoft indicates under the Contains predicate the following restriction "<contains_search_condition> Specifies some text to search for in column. Variables cannot be used for the search condition." Question: What good is the contains predicate if you can't pass variable conditions to it for the full text search. Is there any way around this or are your users suppose to get into your sp and add static text. Ha HaThanks Rich" |
|
|
|
|
|
FullText search - Contains predicate