Advanced Searching

<< Click to Display Table of Contents >>

Navigation:  Concordance > Using Concordance > Searching >

Advanced Searching

Full-text and relational searches each have different pros and cons.  It is important to understand when to use each.  You can combine full-text and relational searches together - allowing you to search free-text paragraph fields and fixed fields at the same time to maximize your query potential.

Comparison of Full-Text versus Relational Searches

Full-Text

Relational

Searches the dictionary, uses index to display words from dictionary search

Searches the database in real time

Very fast

Slower (depending on size of database)

Hit highlighting in red

No hit highlighting

Can only search indexed fields

Can search any field, indexed or not

Easy to search multiple fields at once

Searches one field at a time (unless fields groups are established in the .INI file)

Used more often to find words

Used more often to find dates, numbers, ranges, comparisons

Cannot be used on date fields

Can find specific dates or a range of dates within limits or outside limits

Often used on paragraph fields

Normally used on paragraph fields only to find empty/not empty fields

Cannot be used until the database has been indexed. Will not find new data until database has been reindexed.

Can be used whether or not the database has been indexed

Cannot be used to find stopwords, since they are not in the dictionary

Can be used to find stopwords

Uses the * wildcard character.

Can be used before or after the word.

Uses the * wildcard character only at the end of a word. Use the ? wildcard character, to replace a single character in the middle of a word and in data searches.

Always searches the complete contents of paragraph fields

Only searches the complete contents of paragraph fields when using CO and NC operators