XMLPARSE Syntax - Teradata VantageCloud Lake

Lake - Working with SQL
Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
jbe1714339405530.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
jbe1714339405530
XMLPARSE (
  { DOCUMENT | CONTENT }
  string_value_expr
  { PRESERVE | STRIP }
  WHITESPACE
)

Syntax Elements

DOCUMENT
The function returns an XML document node.
CONTENT
The function returns an XQuery document node.
string_value_expr
The string value to be parsed.
The data type of string_value_expr is CLOB or VARCHAR.
If string_value_expr is NULL, the function returns NULL.
PRESERVE WHITESPACE
White space is preserved during parsing.
STRIP WHITESPACE
White space is removed during parsing.