An SQL primer
Sample predicates (continued):
- col1 LIKE pattern [ESCAPE character]
- Pattern matching:
- _ (underscore) matches exactly one character
- % (percent) matches zero or more characters
- Any other character matches itself
- Use ESCAPE followed by a character if you need to use the actual ‘_’ or ‘%’ characters in your pattern
- character becomes an escape character you can use in your pattern to prevent ‘_’ or ‘%’ from being used for pattern matching