Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Containstable returning incorrect results for term with operator

Status
Not open for further replies.

JZajda

Technical User
Jan 15, 2002
32
US
SELECT id
FROM CaseLaw c join containstable(CaseLaw,CaseText,'("crime and punishment")') ct on c.id = ct.[key]
WHERE (c.CaseType=1 OR c.CaseType=2)

We are using SQL Server 2000 full-text indexing and the script above isn't returning the result set we are expecting. Along with all terms containing "crime and punishment" we are also returning a record that has both terms in it, but they are not in a string "crime and punishment". The places in the record that have the terms crime or punishment are listed below. As you can see they are never together.

...(a) "grossly disproportionate to the severity of the crime" warranting punishment...

...does not purport to be punishment at all must involve more than ordinary...

...right to be free from cruel and unusual punishment. On this claim...

...Eighth Amendment's prohibition against cruel and unusual punishment. See Whitley v. Albers...

...Cruel and Unusual Punishment Clause)...

Has anyone encountered this error before, if so is there a workaround that fixes this issue?

Thanks,
Joy
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top