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

cast as numeric first (so you get the precision you want), then cast as
varchar
Alan