Skip to Content
0
Former Member
Mar 11, 2010 at 07:55 PM

How to extract an element from XML field

16 Views

Hi All,

I have a table which each record contains an xml field. I would like to extract an element out of this xml field. How would I accomplish this?

Example:

<person>

<name>john</name>

<age>30</age>

</person>

In this example I want to extract "30" from the xml field.

Thank you in advance.