I have imported data from Excel into SQL.
When the data arrives in the SQL column it's scientific (E+)
My column in SQL is VARCHAR(20).
This is fine by me, but I need a script that will change the scientific to a normal number.
The formatting of the colum must stay as VARCHAR(20).
Hope you can help.