Subject Cast( float as varchar(20) ) formatting?
Author bwc3068

(Hmmm... I think I somehow blew posting this just a second ago...if this is a repeated post, please excuse)

If I want to cast a float as a string, how do I format it?

(I'd have thought I'd easily find this in the group but couldn't)

Let's say I'm:

CharField = cast( FloatField as varchar(20) )

and FloatField = 1.2345

CharField = "1.23450000000000" how do I cast without all the trailing zeros?