Skip navigation FileNet logo
Glossary  |  Help Directory  
  Help for Process Engine Reference  
  Search  |  Index  
Concepts
  About attachments
  About the Component Integrator
  About launching a workflow
  About milestones
  About operations
About the RMI registry
About rosters
About routing
About rules
  About security
  About security queues
  About step processors
  About step states
  About system maps
  About transfer
  About workflow fields
  About workflow maps
  About workflow participants
  Component queue security issues
  Content Engine (CE) operations
  Coordinate information
  Custom web applications
  Eliminating port 32771 conflicts
  Java Runtime Environment (JRE)
  Maximum index key size
  Naming conventions
  System fields
  Troubleshooting
  Wildcards
  Workflow database field size limitations
  Workflow exceptions
Events & Statistics
Expressions
Procedures
   

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)