This predicate allows for searching on the contents of a fulltext index. The named fulltext index must exist in the table in order to use this predicate.

 

Syntax

 

  <contains predicate> ::= CONTAINS(<SqlName>, <FullTextSearchExpr>)

 

<SqlName> ::= name of existing fulltext index

 

<FullTextSearchExpr> ::= { <FullTextSearchTerm> "OR" }

 

<FullTextSearchFactor> :== [ "NOT" ] [ "STARTS" "WITH" ] <SimpleExpression>

 

<FullTextSearchTerm> :== { <FullTextSearchFactor> "AND" }

 

 

Usage

 

SELECT * FROM Customers

WHERE CONTAINS(idx_ft_name, 'jack' OR 'jill')