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

SELECT customerXML.ISCONTENT()
FROM customer
WHERE customerID = 1;

Query result:

customerXML.ISCONTENT()
-----------------------
                      1