Skip to main content
Mitratech Success Center

Full-Text Search Symbols for Content Search

Some strings used as full-text search criteria may conflict with the database server's list of "stop words" which return an error message. For example, refer to see "Oracle Text Supplied Stop lists".

Symbol Description Sample Search Criteria Sample Search Result


Returns search results that include each word specified. This is useful for indicating multiple terms. claim+fire Claim involving fire on 3rd floor
Second fire damage claim in four years
Purchased fire policy one month before filing claim.


Often referred to as a "fuzzy" search. Returns search results that include words with similar inflections, or forms. ?find The underwriter finds the details of the accident
The policy has been found to cover


Excludes a word from your search. Make sure to include a space before the - sign but not after it. claim -fire Claim involving 3 uninsured persons
Seventh claim in two years

" "

Matches the phrase in quotes exactly. This ensures that results are returned only when the words in quotes appear together. Using quotes only specifies that the spelling and spacing must be matched. The search is not case sensitive.
Tip: Use quotes when searching for a proper noun, such as a person's name or company name.


"San Francisco" Client is based in San Francisco.
The office in San Francisco, which received the FNOL

" " , + , -

This is an example of a search where several symbols are used in combination. "San Francisco" +litigation -expired The litigation that took place in San Francisco in 1999
  You can enter in several words without symbols, to search for instances of any words. If several words are entered but no symbols are used, then the search results include instances of each word by itself rather than all of the words together. San Francisco litigation Tracy Owens, at the office in San Antonio
Francisco Juarez, another witness
Before the litigation was complete

Note: For additional options that may be possible for you to use, ask your database administrator about text query operators.

Depending on your database server, there are certain items that you must avoid during a full-text search. These commonly used words, numbers, and letters are generally not keywords that would uniquely identify the record you are seeking.

Example Items to Avoid During Full-Text Search

Individual Numbers Individual Letters Common Words

0 1 2 3 4 5 6 7 8 9


a b c d e f g h i j k l m n o p q r s t u v w x y z


and or
a an the that this those
but if so
he she you we me it
his her your their my its
in to at on by of for with
before after between
am is was be has
who what when where how
also too

 Note: This list is not comprehensive because the actual behavior of the search depends on your database server and its settings. For more information, consult your database administrator.

  • Was this article helpful?