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.

SELECT *
   FROM MarketingInformation
   WHERE CONTAINS ( Description, 'cotton' );
SELECT *
   FROM MarketingInformation 
   CONTAINS ( Description, 'cotton' );

See FROM clause, and CONTAINS search condition.