I have a table
create table Profiles
(id int,
xml_data xml
)
that has an xml column and for each row i have the same xml that looks like this :
<Profile>
<personalInfo>
<contactInfo>
<firstName>John</firstName>
<lastName>Doe</lastName>
<address>22 Park Avenue</address>
<address2 />
<city>Guilford</city>
<state>CT</state>
<zip>11221</zip>
</contactInfo>
</personalInfo>
<Languages>
<Language> English </Language>
<Language> French </Language>
<Language> German </Language>
<Language> Hungarian </Language>
</Languages>
</Profile>
I want to take just the languages part of this xml and put it in another XML variable.
How do i do that ?