Click here to Skip to main content
15,896,727 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
ContainsTable funtion is not working when we are using or operator.

SQL
SELECT top 100
D.[name], CT.Rank AS RANKR
FROM ContainsTABLE ([DocumentSemantics], [file_stream],
      'java and j2ee and sql or oracle' ) AS CT
 INNER JOIN dbo.[DocumentSemantics] AS D
  ON CT.[KEY] = D.[path_locator]
  order by rankr desc


Result is not releavant if use or operator .


Please help me........
Posted
Updated 8-Jan-16 3:04am
v2

1 solution

You need to be careful when combining AND and OR . Please check the precedence and use parentheses as necessary.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900