Show money in international format in sql server
Sometimes we need to show money in international number format. For eamaple we store money as 26583912.1254 in the database but while showing it in reports we want to show it like 26,583,912.13 which is in international number format.
To convert money is international format here is the code.
DECLARE @Amount MONEY
SET @Amount= 26583912.1254
SELECT @Amount 'Before converting to international number format'
SELECT CONVERT(VARCHAR,@Amount,1)'International number format'
OUTPUT
Hope it will help you.
Stay tuned for more... till then happy reading......