Try using CAST function.
See
Re: Select data from numeric field in formatted manner Thread #
1163837 Message #
1163842You may find this useful as well
Re: Converting money to char Thread #
818579 Message #
818639>Hi
>How to round the result of a column display in sql, when doing something like this, in the enterprise manager:
>
>Select round(TotalCost,2) from Cost
>
>
>But it display something like this:
>
>TotalCost
> 367.60000000000002
> 51.210000000000001
> 740.51999999999998
>
>and I need rounded like this:
>
>TotalCost
> 367.60
> 51.21
> 740.52
>
>Thanks in advance
>Carlos Burgos
If it's not broken, fix it until it is.
My Blog