| Display rupee symbol in SQL Query?
Below is the query to display a rupee symbol in SQL query.
DECLARE @AmountVal money = 1234.56;
SELECT @AmountVal AmountValue,
FORMAT(@AmountVal, 'C', 'en-us') 'US Currency',
FORMAT(@AmountVal, 'C', 'en-in') 'Print Rupee',
FORMAT(@AmountVal, 'C', 'hi-in') 'Print Rupee Extra Space';
And output of above query is :-
 | | |