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 |
|
uberbloke
Yak Posting Veteran
67 Posts |
 Posted - 2001-10-09 : 11:22:38
|
| Can't get my head round this one....I have a full text index on a table (lets call it ... COMPANYDOCS) on the columns (lets call 'em 'displayname' and 'comments').so what I basically want to do is thisselect * from COMPANYDOCSwhere CONTAINS(displayname, 'searchstring;)or CONTAINS(comments, 'searchstring')but with the ranks that containstable provides.I have been playing with containstable and can get it working for a single instance, but for the life of me I can't work out what sort of join'ing etc I need to get this sorted out so that I can get ranking and have an OR type search (all the examples I have found (BoL/web) use single CONTAINSTABLE examples).Any help greatfully recieved!Edited by - uberbloke on 10/09/2001 11:24:48 |
|
|
|
|
|
Index and multiple containstable's