Performing a full text query
You can perform a full text query by using the CONTAINS clause in the FROM clause of a SELECT statement, or by using the CONTAINS
search condition (predicate) in a WHERE clause. Both return the same rows; however, the CONTAINS clause also returns scores
for the matching rows.
For example, the following two statements query the Description column in the MarketingInformation table, and return the rows
where the value in the Description column contains the term cotton. The second statement also returns scores for the matching rows.
See FROM clause, and CONTAINS search condition.