In this article, we will see how to

Scenario

I have a decimal number like 541777367.100000. I need to display it in money format as in the following:

Display Decimal Numbers as Money with Cents

To display decimal numbers as money with cents, you can simply cast the number to money as the following.

  1. SELECT convert(varchar,cast(541777367.100000 as money), 1) as 'Budget'

[Output]



Display decimal numbers as money without cents

To display decimal numbers to money with cents, it will require replacing the cents digit as the following:

  1. SELECT replace(convert(varchar,cast(floor(541777367.100000) as money),1), '.00', '') as 'Budget'

[Output]



Applies To

Conclusion

In this article, we have learned how to

References