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.