hi, i need to cast a value over a million to nvarchar
this is my query:
SELECT cast(cast(round(SUM(Sales.Sales),2) as float) as char) AS Sales from Sales
resulting in 6.56722e+006
I need to display it properly,if i take away the casts i get 6567218.2400000021
is it all these extra zero's causing the trouble ?
i tried char,nvarchar and varchar, but i cant get the result