title: Using XML column in a where clause in SQL 2008
body: <p>I have a stored procedure in which I need to have a where clause that reads something like:   </p>
  
  <pre><code>where XMLDataPoint &lt;&gt; NULL  
  </code></pre>
  
  <p>However, XMLDataPoint is an XML column and I get an error </p>
  
  <blockquote>
    <p>"The XML data type cannot be compared or sorted, except when using the
    IS NULL operator."  </p>
  </blockquote>
  
  <p>How should I structure my where clause?</p>