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 |
|
aiken
Aged Yak Warrior
525 Posts |
 Posted - 2003-11-12 : 20:34:24
|
Ok, let's say I've got tables like this:CREATE TABLE snitz_topics (t_message text)CREATE TABLE keywords(keyword varchar(20)) What I want is a list of topics that match one or more of the keywords... but not just with like, with full-text and FORMSOF(inflectional,keyword).I can do this with a while loop cycling through the keywords table, but is there any way to do this in a set-based manner?Cheers-b |
|
|
|
|
|
Mind-numbing full-text query: doable without loop?