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-10-15 : 08:32:18
|
| Jeremy writes "I was wondering whether anybody knows whether SQL Server 2000 will produce an ANDED version of the FREETEXT commandThe command has the following format:FREETEXT ({column | * }, 'freetext_string')If "freetext_string" has > 1 keywords then the engine ORs these filters together - Is there a way to enforce an AND search here so that multiple, white-spaced seperated keywords are ANDED in the search???Otherwise I'll have to dynamically build the SQL string and I know dynamically built SQL is not as efficient as a stored proc (which is what I'm hoping to use!!!)No big deal I suppose, but a feature like this would be nice ;)ThanksJ" |
|
|
|
|
|
ANDED searches (like FREETEXT but anded...)