d_dude_2003 wrote:

>
> how do i format the float value to a string like ##.##?
>
> something like CAST(MyValue As VARCHAR(5))?
>

That doesn't seem like a very safe thing to do.

Are you sure that all values have a precision of four or
less?

Are you sure that none are negative?

If you're sure of the precision and scale, why declare
the field as float to begin with?


Regards,


Ann