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.