Can you mix FORMSOF INFLECTIONAL with Wildcards???
I've tried it but but get this error:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error near 'testers' in the full-text search condition 'FORMSOF(INFLECTIONAL, "testers*")'.
As far as I can tell from a quick glance at Books Online, you can have prefix terms (like 'testers*'), but I do not see anything about suffix terms. Have you looked into the FREETEXT functions? I am not sure what you are trying to accomplish with this, so it is hard to suggest a solution.
The inflectional search seems to not care if a word is singular or plural. The Thesaurus search definitely cares. The freetext function does not seem to mind singular vs plural, either. So this should work for you:
where contains (columnname, 'formsof (inflectional, "multimeter")')
That should also return the same resultset as
where contains (columnname, 'formsof (inflectional, "multimeters")')
since "multimeter" and "multimeters" are forms of each other. It may be that they get scored differently from one another in containstable. I have not tested that.
I need to use CONTAINSTABLE and RANK Column for ordering.
But in addition to the previous example, i need my recordset to be able to find products such as mft1720 where the search criteria is mft
I'd of thought this kind of search would be quite common, but i've yet to find the answer.
it seems i have the choice of using either FORMSOF INFLECTIONAL or Wildcards.