Both Prepend and Append

If you want Content Manager OnDemand to add a wild card character to the end of the search string and the beginning of the search string, select both Prepend and Append.

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" (Clark, Clarksen, Denmark, and so forth).