![like symboliclinker like symboliclinker](https://www.dreamnix.com/support/AvatarHandler.ashx?radfile=%5cUsers%5c2%5ccpanel%5csymbolic-link2.png)
For example, it would return a value such as 'Hello%'. This Oracle LIKE condition example returns all suppliers whose name starts with H and ends in %. WHERE supplier_name LIKE 'H%!%' ESCAPE '!' Here is another more complicated example using escape characters in the Oracle LIKE condition. This statement will return all suppliers whose name is Water%. This Oracle LIKE condition example identifies the ! character as an escape character. WHERE supplier_name LIKE 'Water!%' ESCAPE '!' Please note that you can only define an escape character as a single character (length of 1). You can do this using an Escape character. Let's say you wanted to search for a % or a _ character in the Oracle LIKE condition. These examples deal specifically with escaping characters in Oracle. It is important to understand how to "Escape Characters" when pattern matching. The example above, would retrieve potentially 10 records back (where the missing value could equal anything from 0 to 9).
![like symboliclinker like symboliclinker](https://static.macupdate.com/screenshots/282792/m/symboliclinker-screenshot.png)
You might find that you are looking for an account number, but you only have 5 of the 6 digits. For example, it could return suppliers whose supplier_name is 'Smith', 'Smyth', 'Smath', 'Smeth', etc. This Oracle LIKE condition example would return all suppliers whose supplier_name is 5 characters long, where the first two characters is 'Sm' and the last two characters is 'th'. Remember that _ wildcard is looking for only one character. Next, let's explain how the _ wildcard (underscore wildcard) works in the Oracle LIKE condition. Example - Using _ wildcard (underscore wildcard)