FullText Search with phrases

Occasional Visitor

Hi,

 

I've set up a FullText search (for French language) on an SQL DB and i'm querying the index using phrases like the following : "BAER module batterie réversible CAD HR basic XL 130"

I'm using CONTAINSTABLE function and i believe its trying to match the whole phrase rather than getting the most suitable match using combination of words in the phrase.

So i believe i need to somehow build a search text using AND, OR etc... to get the best match out of the index or is there some other way to tackle this?

0 Replies