title: SQL Server XQuery to select record if XML Column contains element with value
body: <p>I want to select the records from the Orders table. It contains the OrderXML as XML type column.</p>
  
  <p>if OrderXML has order with status given by user then it should select the record. 
  I am trying following query but not working -</p>
  
  <pre><code>SELECT * 
  FROM   ORDER 
  WHERE  ORDERXML.EXISTS('/Order/header/status/text()="Processing"') = 1 
  </code></pre>