Microsoft SQL Server 7.0 added the ability to search text fields in new ways; the CML application uses one of these, full-text search. With this version of Microsoft SQL Server, two new predicates have been added to Microsoft's Transact-SQL: CONTAINS and FREETEXT. You can use these predicates in an SQL query to find column values that match special full-text query criteria.
The CML application uses only one of these predicates, CONTAINS. It is used only in search queries executed by the following three stored procedures:
These stored procedures are called by the CreateTable method of the Search COM component:
Note The Search component could support the FREETEXT derivative as well, but the CML does not provide FREETEXT as a user-interface choice. Adding this choice would necessitate creating corresponding stored procedures whose SQL queries use the FREETEXT predicate.