SQLServerCentral.com / SQL Server 2008 - General / SQL Server 2008 / Convert exponential Number to non-exponential numbers... / Latest PostsInstantForum.NET v2.9.0SQLServerCentral.comhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 24 Jul 2014 19:44:05 GMT20RE: Convert exponential Number to non-exponential numbers...http://www.sqlservercentral.com/Forums/Topic837704-391-1.aspxWithin SQL Server the max precision (or "length") of a number is 38.So, you could use [code="sql"]SELECT convert(numeric(38,0),cast(@t AS float))[/code]But you have to be careful for several reasons:1) if you try to convert numbers with negative exponent, the conversion from above will return Zero.2) This conversion will not give you the exact number due to internal rounding errors.Example: '3.733241996799E+27' will return fine but '3.733241996799E+36' will be different.3) The conversion will fail for any number larger than 10^38–1.So, you need to decide what you're looking for: a) get rid of the varchar column (just change to float, but still have exponential notation)b) change it to numeric values with the risk of getting results that are slightly off (or require additional rounding routine) and the risk of not being able to convert all values orc) maybe you have a different requirement...Tue, 22 Dec 2009 01:16:17 GMTLutzMRE: Convert exponential Number to non-exponential numbers...http://www.sqlservercentral.com/Forums/Topic837704-391-1.aspxFirst Google entry for "exponential notation":[url]http://en.wikipedia.org/wiki/Scientific_notation[/url]RegardsGianlucaTue, 22 Dec 2009 01:00:47 GMTspaghettidbaConvert exponential Number to non-exponential numbers...http://www.sqlservercentral.com/Forums/Topic837704-391-1.aspxHi Having one issue in my databas. I have one column which is defined as VARCHAR(100) and it is currently holding large amount fields. I know this is not the best design so there is budget to convert all such columns to based on the data.But for now i would like to know how to Convert exponential Number to non-exponential numbers...Ex: one of the column has 3.733241996799E+32Please help me out.thank u sandyMon, 21 Dec 2009 20:06:28 GMTsandhya_vemulla