How to select XML Nodes as Column in Select statement

Hi

I have table with column type as XML and XML that is stored has following structure


 
  
   
     
     
   

  

 

It is possible that XML that is stored can also be as below


 
  
   
     
     
   

  

 


 
  
   
     
  

 

I goal to write a query such that it will only the node i.e. result should like below

RequestType
————
CreateSite
CreateWeb
DeleteSite

I have been trying query(), data() and value() function in the SQL query, but none seems to working

Does anyone have a suggestion on this?

 

Regards,

RK

One of methods that I am using (and is working) now is :SELECT CASE WHEN ResultXML.exist(‘(/Sites/SharePoint/CreateWeb)’)= 1

CREATE TABLE TestTable ([Xml] XML)

Thanks PolishChuck, This is exactly what I was looking for