Formatting Characters | Data Types and Literals | Teradata Vantage - Formatting Characters - Teradata Vantage - Analytics Database

SQL Data Types and Literals

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2025-11-06
dita:mapPath
uds1628112204571.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
exs1472253032394
lifecycle
latest
Product Category
Teradata Vantageā„¢

Use the following characters in the FORMAT phrase to control formatting.

Character Meaning
X

X(n)

The letter X formats the display of character data. Each X represents one character. The data is returned in left-to-right order.

For example, if a column is defined as FORMAT 'X', only the first (leftmost) character of each field value is displayed.

Multiple character positions can be defined either by using the (n) notation, where n defines the length of the string, or by entering the equivalent number of X characters.

Character strings are padded or truncated on the right when they are shorter or longer than the positions defined in the FORMAT phrase.