Using full text search, you can search for terms, prefixes, or phrases (sequences of terms). You can also combine multiple terms, phrases, or prefixes into Boolean expressions, or use proximity searches to require that expressions appear near to each other.
Perform a full text search using a CONTAINS clause in either a WHERE clause, or a FROM clause of a SELECT statement.
