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-11-08 : 10:29:44
|
| Teekam writes "Hi,I am using the full text searh feature of sql server 2000. In this The following query is working fine.Select objmaster.[object_id], objmaster.[object_title], objmaster.[object_type_id], objkeytable.RANK from [object_master] AS objmaster, FREETEXTTABLE(object_master, object_title,'general and ledger') AS objkeytable WHERE objkeytable.[KEY] = objmaster.[object_id]and (object_Id like 'c%' or object_Id like 'p%' )order by rank descbut when I use any ignored word in query, the search criteria becomes 'general and ledger and is', it gives error: "A clause of the query contained only ignored words".What is the best way to remove the ignored words from the search criteria.thanx and regards,teekam." |
|
|
|
|
|
full text search in sql server 2000.