16.20 - Example: Using the CREATE TABLE cstr Table - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Functions, Expressions, and Predicates

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1145-162K

Consider the following table:

   CREATE TABLE cstr 
     (c1 CHAR(3) CHARACTER SET LATIN
     ,c2 CHAR(10) CHARACTER SET KANJI1);
   

INSERT cstr ('abc', '92abc

INSERT cstr ('abc', '92abcFunction Result
SELECT SUBSTR(c2, 2, 3) FROM cstr; '2 a'
SELECT SUBSTR(c1, 2, 2) FROM cstr; 'bc'