Components of a full-text search query

To write a full-text search query, enter the search parameters as part of an Adaptive Server select statement. Then the Enhanced Full-Text Search engine processes the search. The select statement requires:

For example, to return the 10 documents from the copy column of the blurbs table that have the most occurrences of the word “software,” enter:

select t1.score, t2.copy
from i_blurbs t1, blurbs t2
where t1.id=t2.id
and t1.index_any = "<many> <word> software"
and t1.max_docs = 10

Adaptive Server passes the Verity query to the Enhanced Full-Text Search engine to process the search. See “How a full-text search works”.