How to query the XML node stored on database using SQL? [closed]

[x0xar33wx0x]

I'm new to SQL in XML. My project is due after 2 days. I need your help.I wish to perform like below.\[code\]<RCA> <PREVENTION> Bla bla bla. . . . </PREVENTION></RCA>\[/code\]I wish to generate in my html form like..\[code\]PREVENTION: bla bla bla. . . \[/code\]Is there any simple way to query out ?