Using Wildcard Characters

You can use the match string with a number of wildcard characters.

Enclose the wildcard character and the match string in single or double quotes (like “[dD]eFr_nce”).

• The Percent Sign (%) Wildcard Character
  Use the % wildcard character to represent any string of zero or more characters.
• The Underscore (_) Wildcard Character
  Use the underscore ( _ ) wildcard character to represent any single character.
• Bracketed ([ ]) Characters
  Use brackets to enclose a range of characters, such as [a-f], or a set of characters such as [a2Br]. When ranges are used, all values in the sort order between (and including) rangespec1 and rangespec2 are returned.
• The Caret (^) Wildcard Character
  The caret is the negative wildcard character. Use it to find strings that do not match a particular pattern.