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.
sql server – Float to nvarchar
find better solutions for analytics world
find better solutions for analytics world
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.
Data Engineering and BI BLOG 