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

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

Query result:

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