SQL Server convert Expontial to Numeric

1
20

to convert an exponential value to numeric as of always we can use the cast like below

select

 

cast(3.678e+006 as numeric)

will return

3678000

1 COMMENT

LEAVE A REPLY

Please enter your comment!
Please enter your name here