title: Handling NULL value in FOR XML
body: <pre><code>            SELECT Col1
      FROM Table
      WHERE Col2 = 63895746
      ORDER BY Col
      FOR XML PATH,TYPE
  </code></pre>
  
  <p>I dont need NULLS in the result.
   i want result to be wrapped by something like 
       &lt; Cols >&lt; /Cols > even if col1 is null or not</p>
  
  <p>In this example Table doesn't contain any rows for col2 = 63895746 , so i will get an empty result set, so the type directive will make it  NULL and return it</p>