StringBuilder.Append with float
<p>StringBuilder.Append using float is truncating the value.  What is it converting to and how can I stop it from truncating?</p>

<p>AttributeOrder is type float and I am losing precision when building the string.</p>

<pre><code>if ( AttributeOrder != 0 ) 
{ 
    if ( Result.Length &gt; 0 ) 
    { 
        Result.Append( " AND " ); 
    } 
    Result.Append( COLUMN_ATTRIBUTE_ORDER ); 
    Result.Append( "=" ); 
    Result.Append( AttributeOrder ); 
} 
</code></pre>

<p>EDIT: This is legacy code, I cannot change the underlying datatypes. The column in SQL Server is a real and the datatype is float.  I need to present the float as it is filled, as a string for other purposes and not loose precision as is.</p>
