Convert float into varchar in SQL Server without scientific notation

Casting or converting to VARCHAR(MAX) or anything else did not work for me using large integers (in float fields) such as 167382981, which always came out ‘1.67383e+008’.

What did work was STR().