SQL Server Transact Basic to Expert - Search using Contains with Inflectional Match

SQL Server Transact Basic to Expert - Search using Contains with Inflectional Match

This blog show how to use Contains with Inflectional Matches using the Select query

Syntax:
SELECT TableColumns
FROM TableName
WHERE CONTAINS(TableColumnName, ' FORMSOF (INFLECTIONAL, <Simpleterm>) ')



Example:
SELECT Empid, EmpName
FROM dbo.emptable
WHERE CONTAINS(empName, ' FORMSOF (INFLECTIONAL, THESAURUS) ')