17.10 - Example: Using the CREATE TABLE cstr Table - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - SQL Functions, Expressions, and Predicates

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1145-171K
Language
English (United States)

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'