Determines if a TRANSLATE conversion can be performed without producing errors; returns an integer test result. Use TRANSLATE_CHK to filter untranslatable strings. You can choose to select translatable strings only, or untranslatable strings only, depending on how you form your SELECT statement.
| Result | Meaning |
|---|---|
| 0 | The string can be translated without error. |
| NULL | The string result is null. |
| anything else | The position of the first character in the string causing a translation error. The value is a logical position for arguments of type LATIN, UNICODE, KANJISJIS, and GRAPHIC. The value is a physical position for arguments of type KANJI1. |
ANSI Compliance
This statement is a Teradata extension to the ANSI SQL:2011 standard.