|
A pattern can include regular characters and wildcard characters. During pattern matching, regular characters must exactly match the characters specified in the character string. Wildcard characters, however, can be matched with arbitrary fragments of the character string. Wildcard characters are:
'*' – Any string of zero or more characters.
'?' – Any individual character.
To search for character strings that include a wildcard character, a back slash (\) must precede the wildcard character.
When performing string comparisons with LIKE, all characters in the pattern string are significant.
| 