urgent! SQL statement to query xml data type

[ocs2me]

Hi,guys. Thanks first for viewing. Hope to get help from here.Im new to XML.

Below is the data stored in database table under field [Root_Cause_Analysis]


<RCA>
<SUB_PROBLEM_TYPE>
MRD
</SUB_PROBLEM_TYPE>
<SUB_ROOT_CAUSE>
Elaborate below
</SUB_ROOT_CAUSE>
<ELABORATION>
The volume and keypad related features
in multi-ch behavior has been
discussed for very long time. Recently,
we received the final decision from
marketing.
</ELABORATION>
<PREVENTION>
To increase discussion effectiveness
among teams.
</PREVENTION>
</RCA>




My problem is how to select all the data inside tag?

Ex: Select Root_cause_analysis(RCA/PREVENTION) From table1....

and the result should show "To increase discussion effectiveness
among teams."