MSSQL Integrated Full Text Search (iFTS)

Efficiently perform linguistic searches against a wide range of documents and other data stored in SQL Server databases. To use need to Creation of full-text catalogs and full-text indexes. Query: Use FREETEXT, CONTAINS, FREETEXTTABLE, & CONTAINSTABLE to perform FTS against documents, XML data, & textual data columns. Advanced iFTS options including: Complex search expressions (AND, OR, and AND NOT), Inflectional forms and thesaurus synonyms searches using FORMSOF, Proximity searches using NEAR and Weighted searches using ISABOUT term.

Leave a Reply

Your email address will not be published. Required fields are marked *