September 2010
Intermediate to advanced
1704 pages
111h 8m
English
CONTAINS and CONTAINSTABLEThe CONTAINS and CONTAINSTABLE predicates have the following parameters:
• Weighted
The search phrase is the phrase or word that you are looking for in a full-text indexed table. If you are searching for more than one word, you have to wrap your search phrase in double quotation marks, as in this example:
![]()
In this query, you are searching all full-text indexed columns. However, you can search a single column, a list of columns, or all columns. The following example shows how:
You can also use Boolean operators in your search phrase, as in this example:
This example ...