Wildcard Syntax Elements - Advanced SQL Engine - Teradata Database
Database Utilities
- Product
- Advanced SQL Engine
- Teradata Database
- Release Number
- 17.10
- Published
- July 2021
- Language
- English (United States)
- Last Update
- 2021-07-27
- dita:mapPath
- xha1591998860283.ditamap
- dita:ditavalPath
- xha1591998860283.ditaval
- dita:id
- B035-1102
- lifecycle
- previous
- Product Category
- Teradata Vantage™
- char
- One of the following:
- alphabet (uppercase or lowercase)
- digit between 0 and 9
- special character
- Kanji character
- starting_char
- One of the following:
- alphabet (lowercase or uppercase)
- ? (question mark)
- % (percent sign)
- start_range_char
- One of the following:
- alphabet (lowercase or uppercase)
- $ (dollar sign)
- _ (low line or underscore)
- # (number sign)
- alphabet_range
- Two alphabets separated by a hyphen.
- The range can be in ascending or descending order. Both the alphabets should be the same type, either uppercase or lowercase.
- remaining_characters
- One of the following:
- alphabet (uppercase or lowercase)
- digit between 0 and 9
- ? (question mark)
- % (percent sign)
- $ (dollar sign)
- _ (low line or underscore)
- # (number sign or hash mark)
- digit
- Any digit between 0 and 9.
- hyphen_range
- Two alphabets or two digits separated by a hyphen.
- The range can be in ascending or descending order. Both the characters should be the same type, either uppercase or lowercase alphabet or digit.