>> Another possibility is to set coercion rules for new data type for your >> connection, see
>>https://firebirdsql.org/file/documentation/release_notes/html/en/4_0/rlsnotes40.html#rnfb4-msql-set-bind-native-to-legacy-coercion-rules Thanks Vlad! In this example from this link: SET BIND OF DECFLOAT TO DOUBLE PRECISION; SELECT CAST('123.45' AS DECFLOAT(16)) FROM RDB$DATABASE; --double Does this need to be done within every transaction that is started, or per connection/session, or once off per database? Thanks Maya Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel