Re: Searching for multiple words in one field

GM wrote on Wed, 18 Jan 2006 14:39:47 +0100:

> Hello,
>
> I use sqlserver 2005 with fulltext.
> I want to search for multiple words in a single word field.
> How can I do this.
> For example :
> Field to search =
> "Iwanttogohome"
> "homewant"
> "togohome"
>
> Searchquery words = want home
> My example should find all 3 of the results.
> It should find a word if one of the searched words is included (and rank
> it)
>
> Any ideas?

FTS works on the words being indexed based on a word break, and you have no
word breaks. I can't see how you can possibly use FTS to handle this.

Dan


.

Loading