Forum Discussion

Sanjeev Kumar Moloye's avatar
Sanjeev Kumar Moloye
Copper Contributor
Apr 27, 2018

FullText Search with phrases

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?

No RepliesBe the first to reply

Resources