2 easy firebird sql functions to convert any string to real or integer.

String to real

String to integer

Usage example