Example: Using ISCONTENT to Check if an XML Value is a Document Node With Child Elements - Teradata Vantage NewSQL Engine - 16.20

Teradata Vantage™ XML Data Type

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1140-162K
SELECT customerXML.ISCONTENT()
FROM customer
WHERE customerID = 1;
Query result:
customerXML.ISCONTENT()
-----------------------
                      1