70-461 Chapter 6 Lesson 2

2 Articles

The FREETEXT Predicate

Last Updated On : Sunday, May 24, 2015The FREETEXT predicate is less specific and thus returns more rows than the CONTAINS predicate. It searches for the values that match the meaning of a phrase and not just exact words. When you use the FREETEXT predicate, the engine performs word breaking of the search phrase, generates […]

The CONTAINS Predicate

Last Updated On : Sunday, May 24, 2015With the CONTAINS predicate, you can search for the following: – Words and phrases in text – Exact or fuzzy matches – Inflectional forms of a word – Text in which a search word is close to another search word – Synonyms of a searched word – A […]