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+32

Within SQL Server the max precision (or "length") of a number is 38.So, you could use

SELECT convert(numeric(38,0),cast(@t AS float))

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...