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)