Field information for string fields

The following field information choices are available only for string fields:

Wild Card. Determines whether Content Manager OnDemand uses wildcard characters with search values specified by the user, and if so, how to process the wildcard characters. Wildcard characters can only be used with the LIKE and NOT LIKE search operators.

You can select the Append checkbox, select the Prepend check box, select both checkboxes, or clear both checkboxes.

• Append. Content Manager OnDemand automatically adds a wildcard character to the end of the search string. Append is the default wild card . For example, suppose you use the LIKE operator to search a name field for the string "Clark". Content Manager OnDemand uses LIKE 'Clark%' to locate all names that begin with the letters "Clark" followed by zero or more characters (Clark, Clarke, Clarkes, Clarksen, and so forth).
• Prepend. Content Manager OnDemand automatically adds a wildcard character to the beginning of the search string. For example, suppose you use the LIKE operator to search a name field for the string "ark". Content Manager OnDemand uses LIKE '%ark' to locate all names that end with the letters "ark" preceded by zero or more characters (Bark, Clark, Denmark, and so forth). Use caution when you prepend a wildcard character to a search string. If a wildcard character begins the string, Content Manager OnDemand must perform a sequential search of the database even though there might be database fields in the application group defined as index fields.
• If you select both the Append and Prepend checkboxes, Content Manager OnDemand adds a wild card character to the end of the search string and the beginning of the search string. For example, suppose you use the LIKE operator to search a name field for the string "ark". Content Manager OnDemand uses LIKE '%ark%' to locate all names that contain the letters "ark" (Bark, Clark, Clarke, Clarkes, Clarksen, Denmark, and so forth).
• If you clear both the Append and Prepend checkboxes, then Content Manager OnDemand does not automatically add wildcard characters to the search string. If the user does not add a wildcard character to the search string, then Content Manager OnDemand locates only those documents that match the search string exactly.

 Review Searching Database Fields with the LIKE and NOT LIKE Operators for important information.