title: How to convert float to varchar in SQL Server
body: <p>I have a float column with numbers of different length and I'm trying to convert them to varchar.</p>
  
  <p>Some values exceed bigint max size, so I can't do something like this</p>
  
  <pre><code>cast(cast(float_field as bigint) as varchar(100))
  </code></pre>
  
  <p>I've tried using decimal, but numbers aren't of the same size, so this doesn't help too</p>
  
  <pre><code>CONVERT(varchar(100), Cast(float_field as decimal(38, 0)))
  </code></pre>
  
  <p>Any help is appreciated.</p>
  
  <p><strong>UPDATE:</strong></p>
  
  <p>Sample value is <strong>2.2000012095022E+26</strong>.</p>