Queries Invoking Free-text Search

InterSystems IRIS supports what is called “free-text search,” which includes support for:

Wildcards
Stemming
Multiple-word searches (also called n-grams)
Automatic classification
Dictionary management

This feature enables SQL to support full text indexing, and also enables SQL to index and reference individual elements of a collection without projecting the collection property as a child table. While the underlying mechanisms that support collection indexing and full text indexing are closely related, text retrieval has many special properties, and therefore special classes and SQL features have been provided for text retrieval.

For further details refer to Using InterSystems SQL Search.

Pseudo-Field Variables

Querying Collections