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

List of special Characters in HTML

Get Random alphanumeric number with specific length using SQL Server