title: SQL Server: Convert FLOAT to NVARCHAR, maximum accuracy, without scientific notation
body: <p>Without using scientific notation, I need to convert a <code>FLOAT</code> to a string, without showing scientific notation, and capturing all possible precision.</p>
  
  <p>For example, when I execute <code>SELECT 1E0 / 1346E0</code> I get the following result:</p>
  
  <p><a href="https://i.stack.imgur.com/0Cpal.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/0Cpal.png" alt="enter image description here"></a></p>
  
  <p>This is how SQL Server displays a <code>FLOAT</code> value by default.<br>
  In this case, it displays 18 decimal places, which is more than the <code>STR</code> function can provide.<br>
  It also does not add any trailing zeros.</p>
  
  <p>If SQL Server Management Studio can do this, can I also get this conversion in my code?</p>
  
  <p>I need to avoid scientific notation at all costs, even if there are 20 leading zeros after the decimal point. A long string is not a problem.<br>
  Unfortunately, the <code>CONVERT</code> function does not provide what I need, even with style 3</p>
  
  <p><a href="https://i.stack.imgur.com/d71Ct.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/d71Ct.png" alt="enter image description here"></a></p>