Sunday 10 September 2006

Float as Varchar (Not Scientific)

Formatting a float in varchar but NOT in scientific notation
SELECT CONVERT(varchar(100), CAST(@testFloat AS decimal(38,2)))
or
SELECT STR(@testFloat, 38, 2)

No comments: