The following table shows examples for KanjiShift-JIS client character set, where ctable1 is the table defined in "Example: Effect of the Order of SELECT Statements on Data Type" in Teradata Vantage™ - SQL Data Manipulation Language, B035-1146.
| IF c1 contains … | THEN this query … | Returns … |
|---|---|---|
| mnABC X | SELECT SUBSTR(c1, 6, 1) FROM ctable1; | X |
| SELECT SUBSTR(c1,4) FROM ctable1; | BC X |