|
xmlextract()
The
XML function
xmlextract() executes a
XPath ![external link]()
query
against
XML
data. The default return value is a XML document. The
function
xmlextract() follows the same principles as the function
subquery()
and accordingly, returns a substring. If, for example, one specifies the
XPath Operator
text()
for XPath query, the outer XML-Tags are removed.
Syntax of the String Function xmlextract()
xmlextract("XPath_query_expression[XPath_operator]",
xml_data_expression
[[option "optional_parameter"] return_datatype])
The parameters of the XML Function xmlextract()
"XPath_query_expression"
The parameter "XPath_query_expression"
"basic XPath_operator"
See:
XPath_operators.
See also:
ASE T-SQL - Aggregate Functions,
XML Functions.
|
