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