sql server – Float to nvarchar

cast or convert wont work at sql server for converting float to nvarchar

cast([Column_Name] as nvarchar(10)) result would not be as expected.

Use “str” function.