Components of a Full-Text Search Query

To write a full-text search query, you enter the search parameters as part of an Adaptive Server select statement. Then the 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
and t1.index_any = "<many> <word> software"
and t1.max_docs = 10

Adaptive Server passes the Verity query to the Full-Text Search engine to process the search. For more information on how Adaptive Server processes the query, see “How a Full-Text Search Works”.