title: To convert float value to string
body: <p>I am using two columns which have Date and float values, now I need to combine both the columns as a single string. For date I am able to convert it to string. But for the float values it is rounding up the decimal value which should not be the case.</p>
  
  <p>For example my float value is 204.8 and date id 2014-11-11. Now when I combine as string it should result as '2014-11-11 204.8' But it is showing me as '2014-11-11 204' when I convert float value. I am using this query,</p>
  
  <pre><code>DECLARE @myDateTime DATETIME
  DECLARE @StandardCost INT
  SET @myDateTime = '2011-12-24 00:00:00.000'
  SET @StandardCost = 204.8
  SELECT LEFT(CONVERT(VARCHAR, @myDateTime, 120), 10)+ ' ' + CAST(@StandardCost AS VARCHAR(MAX))
  </code></pre>
  
  <p><strong>Result: 2011-12-24 204</strong></p>
  
  <p>Can anyone help me in getting exact float value with decimals as string. </p>