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 following table 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)


Last updated: October 2015
bpfe021.htm

© Copyright IBM Corporation 2015.