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

Comments

Popular posts from this blog

How to Read TOC Headings from word document using C#

List of special Characters in HTML