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)