SQLTeam.com | Weblogs | Forums

Containstable function in semantic database is not working with "or" operator

sql2012

#1

ContainsTable funtion is not working when we are using or operator.

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........


#2

Not familiar with ContainsTABLE however I might suggest parenthesis around "(sql or oracle)".


#3

No it's not working...