How to get Exponential values as decimal in sql server

select Cast ( Cast (columnname as float(20)) as decimal(25,20))  columnname  from table
WHERE CHARINDEX('E',columnname) <> 0 AND ISNUMERIC(columnname)=1


Popular posts from this blog

How to Read TOC Headings from word document using C#

How to Convert Word Document to PDF using C#