Convert Decimal to Money SQL

In this article, I will explain how to Convert Decimal Numbers to Money with cents / without cents in SQL.

You might also like to read How to convert Gregorian date to Hijri date SQL Server 2012


Convert Decimal to Money SQL

I have a decimal number like  71567536.100000, I need to convert it to money format

  • with cents to be like this 71,567,536.10 ر.س
  • without cents to be like this  71,567,536 ر.س

Convert Decimal to Money with Cents in SQL

You can use one of the below quires

SELECT STUFF( convert(varchar, convert(money,71567536.100000),1) , 1, 0,'.') + N' ر.س ' as 'Budget'
SELECT convert(varchar(100), cast(71567536.100000 as money), 1)+ N' ر.س ' as 'Budget'

Output

Convert Decimal To Money With Cents In SQL Server

Convert Decimal To Money Without Cents In SQL Server

You can use one of the below quires

SELECT parsename( convert(varchar(100), cast(71567536.100000 as money), 1),2) + N' ر.س ' as 'Budget'
 SELECT replace( convert(varchar, cast(floor(71567536.100000) as money),1), '.00', '') + N' ر.س ' as 'Budget' 

Note: The second statement faster than the first with 21 NS.

Output

Convert Decimal To Money Without Cents In SQL Server

Conclusion

In conclusion, we have learned how to Convert Decimal to Money SQL Server.

Applies To
  • SQL Server 2016
  • SQL Server 2012
See Also

Leave a Reply