Capabilities of the Full-Text Search Engine

The Full-Text Search Specialty Data Store product performs powerful, full-text searches on Adaptive Server data. In Adaptive Server, without the Full-Text Search engine, you can search text columns only for data that matches what you specify in a select statement. For example, if a table contains documents about dog breeds, and you perform a search on the words “Saint Bernard,” the query produces only the rows that include “Saint Bernard” in the text column.

With the Full-Text Search engine, you can expand queries on text columns to do the following: