16.20 - Example - 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

Assume column a is BYTE(4) and column b is VARBYTE(10).

If these columns contained the following values:

   a             b       
   ------------  ---------
   78790000      43440000 
   68690000      3200 
   12550000      332200

then this function:

   SELECT TRIM (TRAILING FROM a) || TRIM (TRAILING FROM b) FROM ...

returns:

   78794344 
   686932
   12553322