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 |
|
ts_abbott@hotmail.com
Starting Member
36 Posts |
 Posted - 2005-03-07 : 17:26:48
|
Hi,I need to use CONTAINS on two columns as a join condition but I can't get it to work. Here is some code...SELECT c.*FROM Cars cINNER JOIN UserAlerts a ON a.Make=c.Make AND a.Model=c.ModelWHERE CONTAINS(c.CarDescription, a.UsersKeywords) Does anyone know how I can get this to work / what I'm doing wrong? |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-03-09 : 00:58:29
|
| CONTAINS is dependent on having a full text index in place. Do you have the full text search and indexes enabled on the columns you are querying?-ec |
 |
|
|
|
|
|
CONTAINS (column1, column2)