Wednesday, October 25, 2017
No Comments Yet!!!
Display Decimal Numbers as Money with cents Display Decimal Numbers as Money without cents.
Here Pawan Kumar will explain How to Display Decimal Numbers As Money using Transact-SQL
In previous post I have explained Swapping of two numbers without using third variable using dotnet with c sharp
, jQuery: Call function when CheckBox is checked or unchecked
, How to Implement Reorder List (Drag and Drop) using jQuery in ASP.Net
, How To Export HTML Table To Excel Using jQuery Plugin
, and many more articles.
Now I will explain How to How to Display Decimal Numbers As Money using Transact-SQL
So follow the steps to learn How to Display Decimal Numbers As Money using Transact-SQL
Using :- Display Decimal Numbers as Money with Cents
SELECT convert(varchar,cast(541777367.100000 as money), 1) as 'Budget'.
Using :- Display decimal numbers as money without cents
SELECT replace(convert(varchar,cast(floor(541777367.100000) as money),1), '.00', '') as 'Budget'
So, In this tutorial we have learned, How to Display Decimal Numbers As Money using Transact-SQL