Searching for text using SQL scalar search functions
Using examples, this section describes how to use the SQL scalar search
functions in the following ways:
- Using the function CONTAINS to make a query.
- Using the function NUMBEROFMATCHES to determine how many matches
are found in a text document.
- Using the function SCORE to get the relevancy of a found text
document.
Refer to SQL scalar search function and the SQL table-valued function for a description of the syntax.