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?
Hilary Cotter - 30 Jul 2008 11:40 GMT
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.
> Hello
>
[quoted text clipped - 3 lines]
>
> but I get syntax error, any help?