Wednesday, October 25, 2017
No Comments Yet!!!
Display Decimal Numbers as Money with cents Display Decimal Numbers as Money without cents.
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'
if you have some suggestion, question, request on
How to Display Decimal Numbers As Money using Transact-SQL.
Please use the comment box to express your views.
Disclaimer: The code samples and API available at www.sourcecodehub.com are available
absolutely free. You are free to use it for commercial as well as non-commercial
use at your own risk, but you cannot use it for posting on blogs or other tutorial
websites similar to www.SourceCodeHub.com without giving reference link to the original
article. All the code samples and API provided by the authors are solely their creation
and neither the author nor the site are responsible if it does not work as intended.