17.10 - Wildcard Syntax Elements - Advanced SQL Engine - Teradata Database
Teradata Vantage⢠- Database Utilities
- Product
- Advanced SQL Engine
- Teradata Database
- Release Number
- 17.10
- Release Date
- July 2021
- Content Type
- Configuration
- Publication ID
- B035-1102-171K
- Language
- English (United States)
- 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.