full text search on views?

Question

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

vadba SSChampion Points: 11133 More actions · Answer 1

No, you cannot fulltext index a view.

You could try to join the view with the FT table(s). Or use an EXISTS subquery, like this:

SELECT *

FROM vMyView

WHERE EXISTS (SELECT *

FROM ftTable

WHERE ftTable.keyfield = vMyView.keyfield

AND Contains(*, ' "keywords" ')

)