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:

http://freeadhocudf.org/documentation_english/dok_eng_string.html


--
Milan Babuskov

==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================