> > 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.
>
> Milan Babuskov.

I could do with this too! Does anyone have a working link to this library, or another one that does the same thing? (FB1.55)

Thanks,
Steve