| Subject | Cast( float as varchar(20) ) formatting? |
|---|---|
| Author | bwc3068 |
| Post date | 2010-07-08T20:07:35Z |
Hi--
This seems like something that should be easy OR I should've found easily on the group...but...
If I:
CharField = cast( FloatField 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?
Thanks
Kelly
This seems like something that should be easy OR I should've found easily on the group...but...
If I:
CharField = cast( FloatField 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?
Thanks
Kelly