SQL extensions for Index Services are consistent with the SQL supported for full-text search against relational database data. Furthermore, SQL support for full-text searching follows the SQL-3 functional methodology for full-text syntax extensions.
The primary SQL extension consists of the CONTAINS and FREETEXT predicates. These predicates are used to find column values that match special full-text query criteria.
To be consistent with similar features in other products and to make these predicates more extensible, functional notation is used. The high-level syntax is as follows:
The flexibility of the functional style of these two predicates allows easy, upward-compatible future extensions for a third parameter to designate the language used for the query.