Quick question, why are you using float?

😎

The value returned is exactly the same, but in scientific notation. You can change the last parameter of the Convert function which will give you slightly different results

SELECT CONVERT (NVARCHAR(MAX),TEST_VALUE,1 ) AS CONV_P_1 FROM TBL_CONVERT_TO_NVARCHAR;

SELECT CONVERT (NVARCHAR(MAX),TEST_VALUE,2 ) AS CONV_P_2 FROM TBL_CONVERT_TO_NVARCHAR;

SELECT CONVERT (NVARCHAR(MAX),TEST_VALUE,3 ) AS CONV_P_3 FROM TBL_CONVERT_TO_NVARCHAR;

will return this

CONV_P_1

------------------------

3.2106348e+007

CONV_P_2

------------------------

3.210634800000000e+007

CONV_P_3

------------------------

3.2106348000000000e+007

Alternatively you can embed an integer conversion in the conversion call

SELECT CONVERT (NVARCHAR(MAX),CONVERT(INT,TEST_VALUE,0),3 ) FROM TBL_CONVERT_TO_NVARCHAR

Which will return

---------

32106348