16.20 - BOTH
LEADING - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Functions, Expressions, and Predicates

Advanced SQL Engine
Teradata Database
Release Number
Release Date
March 2019
Content Type
Programming Reference
Publication ID
English (United States)

Specifies how to trim the specified trim character or byte from string_expression.

  • BOTH means trim both trailing and leading characters or bytes.
  • TRAILING means trim only trailing characters or bytes.
  • LEADING mens trim only leading characters or bytes.

If you omit this option, the default is BOTH, and the default trim character is a null byte for byte types and a pad character for character types.