You can search using wildcard operators in the keyword field. A wildcard is a special character or character sequence, which is used to match text in a comparison. This allows the display of results containing all related values.
The * wildcard character can be used to replace several characters of a text string at the beginning or end of a string. For example, the text string "OLS*" will find all instances of both "Olsen" and "Olson".
The ? wildcard character behaves differently depending on what type of database your system uses.
If your system uses a SQL Server database and the search is performed in a filter field, the ? character can be used to replace a single character in the text string. For example, the text string "Sm?th" will find all instances of both "Smith" and "Smyth".
If your system uses an Oracle database and the search is performed in a filter field, the ? character used in a text string replaces one character. For example, the text string r?d would return red and rod, but would not return read. The ? character functions in the same way that * does when used at the end of a string For example, the text string Harr? would return Harry, Harrison, or Harrison, W.
The ? wildcard is not supported when searching using a column search field.
The following attribute data types do not support wildcards: Date, Date/Time, Integer, Text, Floating Point, and Currency.