like

With the LIKE operator you can use wild card characters in a search condition to test a text property.

To match one or more characters, use * or %. For example

Last_name LIKE Br*

finds all documents in which the index field Last_name is Br or begins with Br.

To match one character, use ? or _. For example

Last_name LIKE Brow_

finds all documents in which the index field Last_name has exactly five letters beginning with Brow.

You cannot use the LIKE operator to test dates, numeric values, or menu fields, or in a key condition. You can use more than one wild card in a test.

If you are using Advanced Find to search for CS documents based on item ID and using the LIKE operator, use the ? or _ wild card to pad your search value to nine characters.