Subject Re: [firebird-support] Re: [ib-support] Converting DOUBLE PRECISION to VARCHAR
Author Milan Babuskov
sdbeames wrote:
>>> And my output should look like "CPI plus 3.5%"...but I'm getting "CPI plus
>>> 3.5000000%"....
>>> How do I do a straight forward convert from the double precision to the
>>> varchar without the trailing 0's to pad the varchar?
>> You can try some UDF function. If you're running windows, you can use
>> WFORMATFLOAT from wangfunc library.
> link to this library, or another one that does the same thing? (FB1.55)

Take a look at F_FLOATOSTR in FreeAdHocUDF library:

Milan Babuskov

The easiest way to import XML, CSV
and textual files into Firebird: