Multiple conditions

Hello

I'm not very familiar with fulltext search sintax, so I need your help..
In the contains statement I'd like to make a search like:
'FORMSOF (THESAURUS, "*long*") near FORMSOF (THESAURUS, "string*")'

but I get syntax error, any help?

You can't combine operators like this and the wildcard is not
supported within the thesaurus option. The FreeText will do the
nearness/proximity and the thesaurus expansion, but it will not do the
wildcarding.

One thing you could do is expand long for each wildcard term you want
to find. IE have belongs an expansion of long, etc.



On Jul 25, 5:11 am, Carlo <Ca....TakeThisOut@discussions.microsoft.com> wrote:
> Hello
>
> I'm not very familiar with fulltext search sintax, so I need your help..
> In the contains statement I'd like to make a search like:
> 'FORMSOF (THESAURUS, "*long*") near FORMSOF (THESAURUS, "string*")'
>
> but I get syntax error, any help?