IBM FileNet P8, Version 5.2.1            

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.

Table 1. Table of wildcard characters and their functions
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)


Last updated: March 2016
bpfwm007.htm

© Copyright IBM Corporation 2016.