Several of the Teradata SQL string functions are extensions to the ANSI SQL:2011 standard.
To maintain ANSI compatibility, use the ANSI equivalent functions instead of Teradata SQL string functions, when available.
| Change this Teradata string function … | To this ANSI string function in new applications … |
|---|---|
| INDEX | POSITION |
| MINDEX† | |
| SUBSTR | SUBSTRING |
| MSUBSTR† | |
| † These functions are no longer documented because their use is deprecated and they will no longer be supported after support for KANJI1 is dropped. | |
The following Teradata functions have no ANSI equivalents:
- CHAR2HEXINT
- SOUNDEX
- TRANSLATE_CHK
- UPPER
- VARGRAPHIC