Tuesday, 3 January 2012

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

No comments:

Post a Comment