Convert a value from scientific notation to decimal in T-SQL

A VARCHAR value that is in scientific notation can be converted to a DECIMAL value by first converting it to a REAL value, then to the DECIMAL value. For example: This also works with CAST.

Read the Full Article by E Y