Full-Text Search

You can find records that contain specified text anywhere in the database by using a Full-Text Search. The results of the search depend on how up to date the index is. Your administrator can also choose to exclude certain words.

About this task

Full-Text Search is only available for SQL Server databases. If you use SQL Server 2005 or later, you might prefer to use Search 360.


  1. Select Analysis > Full-Text Search.
  2. Select the type of search:
    Word Use the Word Search page to search for specific words.
    Phrase Use the Phrase Search page to search for specific phrases or inflections.
    Fuzzy If you do not know what exact combination of words or phrases to search for, use Fuzzy Search. For example, if you want to specify a sentence and find something with a similar meaning.
  3. Enter one or more words to search for. Separate words with spaces. You can use the wildcard * or %, at the end of words, to match any number of other characters (including no characters).
    Note: You can search for words that contain punctuation and currency symbols if you use an exact match but not for words that start or end with these symbols.
  4. In the Combine area, select either:
    • And (all your specified words must be present for a match)
    • Or (only one of your words need be present for a match).
  5. In the Type area, select either:
    • Normal For a standard search.
    • Soundex To include similar sounding words.
    Note: Soundex does not operate on document type fields (embedded documents) or use synonyms.
  6. Optional: In the Synonyms area, turn on:
    • User Defined - A list of words appears whenever any member of that list is specified in the search terms. All of these words are searched for, in addition to the specified words.
    • Person Name Variants - When searching for people in the database, you can search for different versions of common names. For example, a person in your database might have a given name of Bob. Searching for "Robert" would also find "Bob", "Bobby", "Roberto", and "Rob" as all these names are defined as variants of each other.
      Note: The list of name variants is fixed. Name variants are updated by your database administrator.
  7. Select which fields you want to search:
    • All to search all the indexed fields in the database, and also all Document type fields.
    • All Name Type Fields to select all indexed fields that are assigned semantic types to indicate that they contain name information.
    • Document to search only Document type fields.
    • Non Document to search all indexed fields but no Document type fields.
    • Selection to search a selection of indexed fields that you define.
    Note: "Indexed fields" refers to fields that are indexed using Full-Text Search Indexing in iBase Designer rather than set as Indexed Fields.
  8. Optional: To highlight the words in the record summary, turn on Highlight Words Found.
    Note: When the embedded document in a document type field contains the word being searched for and Highlight Words Found is turned on, the field name is displayed in Red.
  9. Click Search.


In the list of records found by the search, you can:

  • Select each record to check the field values. The word or phrase will be highlighted if you turned on the Highlight Words Found check box before running the search. If the word occurs in an embedded document, then the name of the document field is highlighted in red (Word Search page only).
    If the text is in an embedded document, you need to show the record and then view the embedded document:
    1. Right-click on the record, and select Show.
    2. Right-click on the Document icon, and select View. The application for the document type starts and displays the document, you must have the appropriate application installed for the document type. For example, you cannot view an .xls file if you do not have Microsoft Excel installed.
  • To work on one or more of the records, select the records, right-click and select an action. For example, it might be useful to add records to a set.