I have values like 3,6237679523765e-013 as text. How do I convert this to a decimal?
Scribe gives errors about: Input string was not in the correct format
Try explicit type casting, converting to a double first:
TODECIMAL ( TODOUBLE ( field ) )
You probably won't retain the original precision. My test resulted in:
This Question already has a 'Best Answer'. If you believe this answer is better, you must first uncheck the current Best Answer