title: SQL 'float' data type, when output as XML, causes undesired float result
body: <p>You can try simply:
  table1: has a column1 of type 'float' 
  instead of </p>
  
  <p><code>SELECT column1 from Table1;</code> gives values as seen in table. </p>
  
  <p>Say this returns 15.1 </p>
  
  <p>However, if you try</p>
  
  <pre><code>Select column1 from Table1 
  FOR XML PATH('Table1'), Root('SomeRoot'), TYPE  
  </code></pre>
  
  <p>returns: 1.510000000000000e+001</p>
  
  <p>Has anyone seen this, and how was this fixed?
  thanks in advance :) </p>