Syntax of search arguments
A search argument is the condition that you specify when searching for
terms in text documents. It consists of search parameters and one or more
search terms.
Examples of search arguments are given in Specifying SQL search arguments, and in
a file called search. See the Additional search syntax examples.
The SQL scalar search functions that use search arguments are:
- CONTAINS
- This function uses a search argument to search for text in a particular
text document. It returns the INTEGER value 1 if the document contains the
text, or any relation specified in the search argument. Otherwise, it returns
0.
- NUMBEROFMATCHES
- This function uses a search argument to search in text documents and
returns an INTEGER value indicating how many matches resulted per document.
- SCORE
- This function uses a search argument to search in text documents. It
returns a value for each document found, indicating how well the found document
is described by the search argument.
Note
You use the same syntax in the search arguments of the stored procedure
search and the SQL Table-Valued Function.