Example: Using ISCONTENT to Check if an XML Value is a Document Node With Child Elements

Teradata Vantageā„¢ XML Data Type

brand
Software
Teradata Vantage
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