Skip navigation FileNet logo
Glossary  
  Help for Personal Work Manager  
  Search  |  Index  
Personal Work Manager
How Personal Work Manager is organized
Toolbar and symbols
Open assigned work
Open unassigned work
Refresh the display
Open the next set of results
Manage the display of work
Customize column display
Set user preferences
  
   

Wildcards

When searching using string comparisons, you can use the LIKE operator combined with a special character known as a wildcard. The table below lists some of the common wildcards for Oracle and Microsoft SQL Server.

Function
Oracle character Microsoft SQL Server character

Matches exactly one character in the value.

_ (underscore)

_ (underscore)

Can match zero or more characters in the value. Note that the pattern '%' cannot match a null.

% (percent sign)

% (percent sign)