Stellent Content Server, Руководство пользователя

Страница: 75 / 198

Stellent Content Server User Guide 5-27
Finding Files
SQL Server Database Full-Text Wildcards
A wildcard substitutes for unknown or unpredictable characters in the search term.
The following wildcard can be used in SQL Server database full-text search fields
(only when used following a prefix):
❖
An asterisk (*) stands for zero or more alphanumeric characters. For example:
• form* matches form, formal, and formula
SQL Server Database Full-Text Search Operators
The following operators can be used to refine your SQL Server database full-text search
expression.
Note: For clarity, the operators are shown in upper case, but they can be in lower case
as well.
Operator Description Example
AND Finds content items that contain all
of the specified terms.
address AND name returns content
items that contain both specified
words.
AND NOT Finds content items that contain the
first term, but not the second term.
address AND NOT name returns
content items that contain the first
word, but not both words.
OR Finds content items that contain at
least one of the specified terms.
safety OR security OR protection
returns content items that contain at
least one of the three words.
“phrase” Finds content items that contain the
phrase specified between the
quotes.
“address change” returns content
items that contain the exact
specified phrase.
NEAR Finds content items that contain the
specified terms in close proximity
to each other.
internet NEAR server returns
content items that contain the
specified words close to one
another.