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 |
|
John Sourcer
Yak Posting Veteran
91 Posts |
 Posted - 2009-03-29 : 09:42:55
|
| Hey All,Trying to do a multiple word query with containstable, but get no results. A either single word works fine. Does 'term1 and term2' not work in ContainsTable?Also can this be done across multiple columns? i.e. when term1 is in one column and term2 is in another column? |
|
|
John Sourcer
Yak Posting Veteran
91 Posts |
Posted - 2009-04-02 : 10:32:13
|
| Shameless bump! If I have 2 columns both indexed, can I get a result for say 'term1' + 'term2' when they are in different columns? |
 |
|
|
|
|
|
Containstable with multiple words