Hi Olaf!

Try this:
select cast('+0.2000000E+01' as double precision) from rdb$database

Andr�s

From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: Wednesday, February 28, 2018 7:44 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] exponential, string to double precision


Hello,

is there a simple function to convert a string "+0.2000000E+01" to a number, double precision, in this case to 2.0?

Thank you

Best regards

Olaf



__________ Information from ESET Mail Security, version of virus signature database 16977 (20180228) __________

The message was checked by ESET Mail Security.
http://www.eset.com



__________ Information from ESET Mail Security, version of virus signature database 16977 (20180228) __________

The message was checked by ESET Mail Security.
http://www.eset.com



[Non-text portions of this message have been removed]