SQL Functions

xpath_long(xml, xpath) – Returns a long integer value, or the value zero if no match

xpath_number(xml, xpath) – Returns a double value, the value zero if no match is found,

xpath_short(xml, xpath) – Returns a short integer value, or the value zero if no match

xpath_boolean(xml, xpath) – Returns true if the XPath expression evaluates to true, or if a

xpath_double(xml, xpath) – Returns a double value, the value zero if no match is found,

xpath_float(xml, xpath) – Returns a float value, the value zero if no match is found,