| Subject | Re: [firebird-support] Cast( float as varchar(20) ) formatting? |
|---|---|
| Author | Milan Babuskov |
| Post date | 2010-07-19T09:16:42Z |
bwc3068 wrote:
?
--
Milan Babuskov
==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================
> CharField = cast( FloatField as varchar(20) )cast(cast(FloatField as decimal(18,4)) as varchar(20))
>
> I end up with:
>
> 1.2345 = "1.2345000000000000"
>
> How do I format it so the trailing "0"s are NOT in the return string?
?
--
Milan Babuskov
==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================