Search This Blog

Wednesday, February 16, 2011

Convert exponential Number to non-exponential numbers in SQL Database

SELECT


or

SELECT
convert(varchar(10),5.0000000000000003E-2) 
convert(varchar(10),cast(5.0000000000000003E-2 AS float))

No comments:

Post a Comment