SELECT ExtractValue('<tag1>test</tag1>','/tag1/') AS result;
result
test
SELECT ExtractValue('<tag1><![CDATA[test]]></tag1>','/tag1/') AS result;
result
test