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