Hello András,

so simple, thank you very much 😊


-----Ursprüngliche Nachricht-----
Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Gesendet: Mittwoch, 28. Februar 2018 07:50
An: firebird-support@yahoogroups.com
Betreff: RE: [firebird-support] exponential, string to double precision

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]



------------------------------------

------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
------------------------------------

Yahoo Groups Links