title: XML within SQL - sql:column removing trailing 0s from a numeric value
body: <p>I am currently trying to insert XML into a SQL table that I use for comparisons between historical records and am encountering an issue that using sql:column on a  numeric datatype column is removing any trailing 0s from the record being put in, causing false comparisons to be made.</p>
  
  <p>The code is something like this:</p>
  
  <pre><code>SET Changes.modify('insert &lt;FinancialAmount&gt;{sql:column("c.Value")}&lt;/FinancialAmount&gt; after (/Name)[1]')
  </code></pre>
  
  <p>However, a value which is 750.00 in the database is returned as simply 750.</p>
  
  <p>I looked into fn:format-number, but it seemed like it wasn't supported within SQL.</p>
  
  <p>Any advice on how to get around this issue would be appreciated.</p>