How do I convert a float to varchar without loss of decimal places? SQL Server 2012

SQL Server 2012: converting a float to varchar is removing decimal places.

For example:

select convert(varchar, cast(834.7833 as float))

returns a varchar with 834.783.

How do I convert a float to varchar without loss of decimal places?

This is a similar question to this unanswered question:

Solution

Why do you need to do a CAST(... AS FLOAT) at all??

Try these snippets - they return the full number of decimal points:

SELECT
    CONVERT(VARCHAR(20), 834.7833)

SELECT
    CAST(834.7833 AS VARCHAR(20))

Both of these output this result:

834.7833